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

Answer Posted / aj.com

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT
MAX(SALARY) FROM EMPLOYEE)

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain me what the webdriver supported mobile testing drivers do you know?

590


What are the pre-requisites to start automation testing?

483


I want to learn the data base testing, how can I start my psactice? I already reading the books of basic for data base? If any other books that make my study simple please suggest.

1571


Tell us what is the difference between single slash (/) and a double slash ( //) in xpath?

648


1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?

1821






how to use regular expression in Test Complete Functional tool

4910


wat is database testing....how to develop data driven framework in selenium enviromnent. please explaing in detail

1632


Name some of the commonly used automation testing tools that are used for functional automation.

525


How can you switch back from a frame?

540


Tell us what is junit? And what is junit annotation?

534


What are pros and cons of automating tests at ui layer?

555


How do you decide which tool you have to use?

555


What type of scenarios can't be automated?

576


What are different coverages in function testing?

612


What is meant by the automation framework?

546