leetcode 181 超过经理收入的员工

超过经理收入的员工

 

select e1.name as Employee from
Employee e1, Employee e2
where e1.managerId = e2.id
and e1.salary > e2.salary

 

select e1.name as Employee 
from Employee e1 left join Employee e2
on e1.managerId = e2.id
where e1.salary > e2.salary

 

==