Tuesday, 6 September 2011

The best Query to Find out 2nd, 3rd, 4th etc salary from a table

select top 1 * from dupemp where salary in 
(select distinct top 4 salary from dupemp order by salary desc)
order by salary
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)