leetcode - 181. Employees Earning More Than Their Managers

난이도 : Easy

 

 

join을 활용한 방법

SELECT staff.name Employee
FROM Employee staff
     JOIN Employee manager ON staff.managerId = manager.id
                           AND staff.salary > manager.salary

Accepted

 

 

테이블 2개를 from절로 가져오는 방법

SELECT e1.name Employee
FROM Employee e1
    ,Employee e2
WHERE e1.managerId = e2.id
AND e1.salary > e2.salary

Accepted