Write a query to find second highest salary of an employee.
- 72 Answers
- 109256 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
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
what is the difference between Batch test runner and framework ?
Simplify the term defect severity.
What is functional and regression testing?
Do you know how to check if a button is enabled on the page?
Give some examples for defect management tools?
Tell me how could ajax controls be handled in webdriver?
What is the major difference between Functional test, Acceptance test, Usability test and performance test. With special reference to automotive domain
Tell me what is the purpose of getoptions() method?
Explain what sikuli is?
What is vendor tool and give examples?
What is in-house tool?
What is testng and why is it better than junit?
How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.
How automation process is carried out?
What all different approaches can be used for designing an automation solution?
