Have a fun while searching

Wednesday, July 21, 2010

Find Second Heighest salary

select top 1 t1.salary from
(select top 2 salary from dbo.tdemos order by salary desc)t1 order by salary asc
Posted by Amit Ji at Wednesday, July 21, 2010

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)