SK
.
SHATRUGHNA
KUMAR
ARCHITECTURE / ENGINEERING
Home
Expertise
Insights
About
Let's connect ↗
The Tech Pursuit
The Dev Shelf
Pages
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