second highest salary use the subquery

[Ram Prakash]

select max(sal) from emp
where sal not in (select max(sal) from emp)

[Rabbit]

Please use code tags when posting code or formatted data.

Did you have a question?

[gaurishere]

SELECT max(sal) FROM emp WHERE salary < (SELECT max(sal) FROM emp);


even u can check ur self 
1 select max(sal) from Emp;
         MAX(SALARY)
--------------------
                28.3

select sal  from Employee order by sal desc
  2  /

              SALARY
--------------------

                28.3
                  12
                 5.5

SELECT max(sal) FROM emp WHERE salary < (SELECT max(sal) FROM emp);
         MAX(SALARY)
--------------------
                  12

easy way to understand