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

Answer Posted / dharmaraj

SELECT max(salary) as salary FROM Employee WHERE salary <
(SELECT max(salary) FROM Employee)

Is This Answer Correct ?    67 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me what is the purpose of getoptions() method?

525


Do you know the difference between close and quit command?

493


Tell us the line of code webdriver driver = new firefoxdriver();.?

511


Tell me how a text written in a text field could be cleared?

513


What are the main attributes of test automation?

1532






Tell me what is regression testing?

550


Can we find all links on a web page?

525


how to know whether the user information or any other information which is entered in to the web is storing in secured place or non secured place?

1570


In Selenium how a test suit is run and report is generated.

1956


What are the types of framework used in software automation testing ?

500


What are the different types of an automation tool that you are aware of?

570


I am fresher and i have completed my software testing course and i don't have real time experience,can anybody help me regarding financial domain projects,main testcases in that domain.

1790


what is aom and how to add object repository? i am very new to QTP please help me

1448


Name the frameworks that are used in software automation testing?

531


Do you know when autoit is used?

563