[리트코드/SQL] 14. Second Highest Salary (176)

👉https://leetcode.com/problems/second-highest-salary/?envType=study-plan&id=sql-i

Second Highest Salary - LeetCode

 

---

🤔 문제 분석

1) Write an SQL query to report the second highest salary from the Employee table. If there is no second highest salary, the query should report null.

 

💡 풀이

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

 

✍️ check point!

서브쿼리