nth highest salary in sql server

Friday, 5 April 2013

nth highest salary in sql server



SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
Posted by Vikash Sinha at 11:27
Labels: , ,

No comments:

Post a comment

Subscribe to: Post Comments (Atom)