nth Highest Salary in SQL Server 2005






3.33/5 (3 votes)
SELECT salary FROM TN a
WHERE n - 1 = (SELECT COUNT(salary) FROM TN b WHERE b.salary > a.salary)
3.33/5 (3 votes)
SELECT salary FROM TN a
WHERE n - 1 = (SELECT COUNT(salary) FROM TN b WHERE b.salary > a.salary)