176. Second Highest Salary

https://leetcode.com/problems/second-highest-salary/submissions/

Second Highest Salary - LeetCode

select max(salary) as SecondHighestSalary from Employee
where salary < (select max(salary) from Employee);

/*
select salary as SecondHighestSalary from 
(
    select salary
    from Employee
    order by salary desc
    limit 2
) as a
order by SecondHighestSalary asc
limit 1;
*/