can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
we have to use distinct key word there is a possibility that two person having same salary. select top 1 sry from (select distinct top 2 sry from emp order by sry desc)t1 order by sry asc
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
