leetcode Employees Earning More Than Their Managers 풀이

self 조인 leetcode 문제

• https://leetcode.com/problems/employees-earning-more-than-their-managers/

풀이

• 주의할 점은 a.managerId = b.id 임.
• a.managerId 가 3,4 = b 테이블과 비교했을 때, 1,2번이 조인 결과로 나옴.

select
    a.name as Employee
from
    Employee a inner join Employee b
    on a.managerId = b.Id
where 
    a.salary > b.salary
;