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

Answer Posted / ravi

I write this query and it run !!

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


Plz reply if anyone having generic answer. :-)

Thanks

Is This Answer Correct ?    313 Yes 56 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What criteria do you consider for automating a test?

521


When will you not automate testing?

571


Do you know how can we make one test method dependent on other using testng?

534


What is difference between selenium and QTP tools Which is best tool... Which is most used tool

906


IS DATA INTEGRITY TESTING AND INTEGRATION TESTING ONE AND THE SAME?IF DIFF CAN U SPECIFY THE DIFFERENCES

1565






Please name a couple of standard web function found in the function generator?

488


How do you plan test automation?

1429


Explain how to perform load-testing?

580


What are the pre-requisites to start automation testing?

459


How can you switch back from a frame?

515


pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?

1660


What is mean by ARGO testing? Can you please explain anyone

1576


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?

1554


How the object properties will be recognised by the tool If the functions/ statements are written manually?

1723


Bug report formate in bugzilla

1605