the above query is the solution for second highest salary

select max(sal) from (select sal from emp where sal != (select max(sal) from emp))