How to find out the 2nd highest salary in SQL

select top 1 * from (select top 2 * from emp order by salary desc) as temp_table order by salary