181. 超过经理收入的员工

select a.Name as Employee from employee a 
left join employee b on b.id = a.managerID
where a.Salary > b.Salary

 

posted @ 2020-12-23 11:24  巴黎爱工作  阅读(80)  评论(0编辑  收藏  举报