this query will find 6th highest salary
SELECT TOP 1 salary
FROM (SELECT DISTINCT TOP 6 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
This blog is started to provide, MS Technologies and Javascript codesnippet which will reduce your time.
No comments:
Post a Comment