nth Highest Salary in SQL Server 2005

Mohd_Ahmad

3.33/5 (3 votes)

16 Feb 2011CPOL

26.2K

SQL

SELECT salary FROM TN a 
    WHERE n - 1 = (SELECT COUNT(salary) FROM TN b WHERE b.salary > a.salary)

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)