Friday, October 17, 2008

Find n th highest salary

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

No comments: