Find 1, 2,3 and nth highest salary
select top 1 salary from (
select distinct top n salary from tab order by salary desc ) a
order by salary asc
Showing posts with label nth highest salary. Show all posts
Showing posts with label nth highest salary. Show all posts
Tuesday, June 8, 2010
Subscribe to:
Posts (Atom)
+of+IMG_1821.jpg)