Try this query
--Nth Highest Salary Query
DECLARE @SalaryPosition int
SET @SalaryPosition = 5
SELECT *
FROM Employee E1
WHERE @SalaryPosition =
(
SELECT COUNT(DISTINCT E2.Salary)
FROM Employee E2
WHERE E2.Salary >= E1.Salary
)
commented on Jan 25 2012 12:09PM