The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment