can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
select top 1 * from (select top 2 * from emp order by sal desc ) a order by sal asc Plz try this.
Site Map
