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