176. Second Highest Salary

/* Write your PL/SQL query statement below */
select max(salary) SecondHighestSalary  from (select * from employee where salary not in ( select max(salary) from employee));