Second Highest Salary.md

⚙문제보기

🔎문제 풀이 MySQL

SELECT MAX(salary) AS SecondHighestSalary
FROM Employee
WHERE salary < (SELECT MAX(salary) FROM Employee)

OR

SELECT MAX(salary) AS SecondHighestSalary
FROM (
  SELECT *, DENSE_RANK() OVER(ORDER BY salary DESC) AS rank_desc
  FROM Employee
) T1
WHERE rank_desc = 2;