Write a query to find second highest salary of an employee.
Answer Posted / raaghav
Try this query
===================
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
where n > 1 '(n is always greater than one)
E.g.:-
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 6 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If i am doing the automation of test suites in a project. Then what will be the system interfaces for that?? The tools I am using or something else... please help..!!
What are different coverages in function testing?
Can any one give information on "Content Disposition" in TEST COMPLETE automation tool? mail me to pdamarakonda@smart-bridge.co.in call me to 09849423932
List of Test Management Tools??Is Quality Center Test Management tools
What are the limitations of automating software testing?
Tell us how to select a value in a dropdown?
How do you decide which tool you have to use?
Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com
What is meant by the automation framework?
Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines
What steps are needed in developing and running a software test?
List down the primary features of a good automation tool?
Tell me what kind of tests should not be automated?
how to write ciertification in QTP?
How do you plan test automation?