Many time interviewer ask “How to find Nth Highest Salary of Employee”. Here is a query for this
The following solution is for getting 2nd highest salary from Employee table
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 2 salary
FROM employee
ORDER BY salary DESC) Emp
ORDER BY salary
You can change and use it for getting 3rd highest salary from Employee table as follows
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) Emp
ORDER BY salary
so you can find nth highest salary also using same query.