176-topSecondSalary.sql 211 Bytes
/* Write your PL/SQL query statement below */
with s as (
select distinct Salary
from Employee 
order by Salary desc)
select max(salary) SecondHighestSalary
from (select salary, rownum nm from s) t
where nm = 2