Friday, 27 February 2015

Find nth highest Salary in database




SELECT FROM Student stud1
WHERE (N-1) = (SELECT COUNT(DISTINCT(stud2.rank))
FROM Student stud2
WHERE stud2.rank > stud1.rank)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)