리트코드(LeetCode) SQL 문제풀이 - 176. Second Highest Salary
2023. 1. 23. 20:22ㆍ코딩테스트/리트코드(LeetCode) - SQL Study Plan
MySQL 문제 176. Second Highest Salary
select MAX(salary) as SecondHighestSalary
from Employee
where salary NOT IN (select MAX(salary) from Employee)
728x90
'코딩테스트 > 리트코드(LeetCode) - SQL Study Plan' 카테고리의 다른 글
| 리트코드(LeetCode) SQL 문제풀이 - 1581. Customer Who Visited but Did Not Make Any Transactions (0) | 2023.01.23 |
|---|---|
| 리트코드(LeetCode) SQL 문제풀이 - 175. Combine Two Tables (0) | 2023.01.23 |
| 리트코드(LeetCode) SQL 문제풀이 - 608. Tree Node (0) | 2023.01.23 |
| 리트코드(LeetCode) SQL 문제풀이 - 1795. Rearrange Products Table (0) | 2023.01.22 |
| 리트코드(LeetCode) SQL 문제풀이 - 1965. Employees With Missing Information (0) | 2023.01.22 |