[leetcode][DataBase] - 176. Second Highest Salary with [MySQL]

problem

select ifnull((select distinct Salary from Employee order by Salary desc limit 1,1), null) as SecondHighestSalary;

or other

select max(Salary) as SecondHighestSalary from employee where Salary < (select max(Salary) from employee);