https://leetcode.com/problems/employees-earning-more-than-their-managers/description/
SELECT e.name AS Employee
FROM employee AS e
INNER JOIN employee AS m ON e.managerid = m.id
WHERE e.salary > m.salary
느낀 점 및 정리 ✍️
1. 셀프 조인을 사용하였다
'Algorithm & SQL > LeetCode' 카테고리의 다른 글
| [LeetCode 197번 / MySQL] 197 : Rising Temperature (0) | 2024.03.10 |
|---|---|
| [LeetCode 183번 / MySQL] 183 : Customers Who Never Order (0) | 2024.03.10 |
| [LeetCode 1179번 / MySQL] 1179 : Reformat Department Table (0) | 2024.03.10 |
| [LeetCode 182번 / MySQL] 182 : Duplicate Emails (0) | 2024.03.10 |
| [LeetCode 595번 / MySQL] 595 : Big Countries (0) | 2024.03.10 |
