Write a query to find second highest salary of an employee.

Answer Posted / lokesh kanithi

Select * from emp e where 2=(select count(Distinct(esal))
from emp where e.esal<=emp.esal)

Is This Answer Correct ?    27 Yes 22 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which package can be imported while working with webdriver?

802


What is functional and regression testing?

615


Do you know how to verify if the checkbox/radio is checked or not?

525


WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?

1766


Give some examples for performance test tools?

601






IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?

1865


WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT

1715


Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)

4924


Please explain what is a relative xpath?

561


Tell me what is regression testing?

545


can any one tell me the examples of white box testing

1995


if we are using an Engine (tool)..with that how to capture data from excel sheets and how to do automation with this plz answer any body for this question.?

1553


What are the disadvantages of Hybrid framework

5671


Hi, Below is the code that i ran on selenium RC using eclipse IDE and java coding.: package source; import org.testng.annotations.BeforeSuite; import org.testng.annotations.Test; import com.thoughtworks.selenium.*; public class parameterized extends SeleneseTestCase { private Selenium browser; public static void main(String []args) { String arr[] = new String[5]; arr[0]= "bert"; arr[1]= "regular"; arr[2]= "copyonly"; arr[3]= "doert"; arr[4]= "inter"; parameterized obj = new parameterized(); obj.setUp(); obj.login_parameterize(arr); } @BeforeSuite public void setUp() { browser = new DefaultSelenium("localhost",4444, "*chrome", "http://goolge.com"); browser.start(); browser.open("http://goolge.com"); browser.waitForPageToLoad("30000"); browser.windowMaximize(); browser.open("/"); browser.click("gb_23"); } @Test public void login_parameterize(String[] arr ) { for(int i=0;i<=5;i++) { for(int j=0;j<=2; j++) { browser.type("//input[@id='Email']", arr[i]); browser.type("//input[@id='Passwd']", arr[i]); browser.click("//input[@id='signIn']"); browser.waitForPageToLoad("30000"); } } } public void EnterValuesIntoTextField_CheckWithGetValue() throws Exception { selenium.open("http://www.essaywriter.co.uk"); assertEquals("", selenium.getValue("id=textInput")); selenium.type("id=textInput", "Text In The Field"); assertEquals("Text In The Field", selenium.getValue("id=textInput")); } } When i ran this test i got an error which says: "Method login_parameterize requires 1 parameters but 0 were supplied in the @Test annotation." Any help is much appreciated. thank Gab

2143


HOW DO YOU PERFORM SECURITY TESTING TO VERIFY FIREWALLS,PASWORD ENCRYPTOPNS ETC?

1820