Write a query to find second highest salary of an employee.
Answer Posted / jawad humayun
SELECT MIN(salary)
FROM employ
WHERE salary IN (SELECT salary
FROM employ
ORDER BY salary DESC
LIMIT 2)
This querry will give the 2nd highest salary
to have nth highest salary replace 'LIMIT 2' by 'LIMIT n'
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
IS DATA INTEGRITY TESTING AND INTEGRATION TESTING ONE AND THE SAME?IF DIFF CAN U SPECIFY THE DIFFERENCES
What are the important modules of an automation testing framework?
Tell me what is regression testing?
What is the difference between close and quit command?
Explain me which web driver implementation is the fastest?
What is mean by ARGO testing? Can you please explain anyone
What you know about table-driven testing?
When you will not automate testing?
Stop automating the tests which run once?
What are the attributes of a good framework?
What is junit? And what is junit annotation?
I am surekha new commer for this site? I have some doubt's pls clarify it..... I finished my B.tech and S/w Testing Course Now iam searching for a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,Matrix for Banking,ERP Projects etc.Here is my email id surekhai@yahoo.com
Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com
What are the steps to perform Load and Stress testing on a Website? What resources do I need to do this? Please advise. Thanks in advance.
5. What are the tests you are conducting through winrunner?