Wednesday, April 19, 2006

Find Nth highest Salary

Its done like:-

SELECT MIN(SALARY) FROM EMPLOYEE
WHERE SALARY IN (SELECT DISTINCT TOP N SALARY FROM EMPLOYEE ORDER BY SALARY DESC)
---------------------------

No comments: