leetcode 181

发布时间 2023-04-11 15:21:50作者: Carl_ZhangJH

超过经理收入的员工

 

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

 

==