nth highest salary in sql server
Developer
By the Developer, For the Developer.
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
No comments:
Post a comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a comment