SQL/LeetCode

[LeetCode] 176. Second Highest Salary

yeyeyep 2025. 2. 17. 17:14

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

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