can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
This query is generalised query if u replace 2 by 100 , then you will get 100th max salary select top 1 salary from employee where salary in( select top 2 salary from employee order by salary desc) order by salary 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
