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
Mention a few good practices while performing automation testing.
Explain some disadvantages to manual software testing?
Which is the best place to learn Loadrunner performance testing in hyderabad ?
What is the difference between close and quit command?
Elaborate the scripting standard while executing testing
Elaborate the fields in bug report in automated testing
Explain me what the webdriver supported mobile testing drivers do you know?
what is nTier Architecture understanding what is Microsoft ASP.net, ASP and SQL understanding what is Web Application and eCommerce application understanding what is Unit, System, Regression, FAT testing ? Test Automation and Test Script Authoring
How many test cases have you automated per day?
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
What is junit annotation?
i need test cases for defect maganement tools
i have one answer from you that today the test cases are not stored in the database(SQL server 2005). But in automation testing where does the test case store? plz tell me... i have more confusion
Hi all, Do anyone have the experience in PDF Document Automation using OLE objects and methods? If so suggest the best websites for source. Thanks :-)
In what condition we cannot use automation testing for agile method ?