Second Highest Salary

[Jacobvu84]

select
   (select distinct Salary 
   from Employee order by salary desc 
   limit 1 offset 1) 
as SecondHighestSalary;

[Jacobvu84]

SELECT  MAX(SALARY) AS SecondHighestSalary FROM EMPLOYEE WHERE SALARY <>(SELECT MAX(SALARY) FROM EMPLOYEE);

SELECT
    IFNULL(
      (SELECT DISTINCT Salary
       FROM Employee
       ORDER BY Salary DESC
        LIMIT 1 OFFSET 1),
    NULL) AS SecondHighestSalary