can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
1 My Second Answer. Select Top 1 * From Tablename where salary in (select top 2 salary from tablename order by salary desc) order by salary asc.