Click here to Skip to main content
15,352,714 members
Articles / Database Development / SQL Server

nth Highest Salary in SQL Server 2005

16 Feb 2011CPOL
SELECT salary FROM TN a WHERE n - 1 = (SELECT COUNT(salary) n FROM TN b WHERE b.salary > a.salary)
Only logged in members can view this content

Please go to the SQL Server Table of Contents to view the list of available articles in this section.