Msbi Knowledge sharing blog
I would like to share my knowledge and open to recieve knowledge from others.
Thursday, 8 November 2012
How to find the nth highest salary with out using top clause or subquery?
SELECT *
FROM EmployeeRecord e1
WHERE (2-1) = (
SELECT COUNT(DISTINCT(e2.Salery))
FROM EmployeeRecord e2
WHERE e2.Salery > e1.Salery)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment