65.9K
CodeProject is changing. Read more.
Home

nth Highest Salary in SQL Server 2005

starIconstarIconstarIcon
emptyStarIcon
starIcon
emptyStarIcon

3.33/5 (3 votes)

Feb 16, 2011

CPOL
viewsIcon

26180

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