[LeetCode 181번 / MySQL] 181 : Employees Earning More Than Their Managers

 

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. 셀프 조인을 사용하였다