April 21, 2010

Find third highest largest Salary

SELECT Salary FROM dbo.Employee EMP1
WHERE
3-1 =
(
SELECT COUNT (DISTINCT Salary) FROM dbo.Employee EMP2
WHERE
EMP2.Salary > EMP1.Salary
)

No comments:

Post a Comment