Click here to Skip to main content

SQL-Server-2005

nth Highest Salary in SQL Server 2005

Tanna

16 Feb 2011CPOL

1.4K

1

3

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.

Go to top