176-topSecondSalary.sql 211 Bytes Raw Blame History Permalink 1 2 3 4 5 6 7 8 /* 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