181. 超过经理收入的员工
2018-09-06 本文已影响0人
在做算法的巨巨
用inner join，输出符合要求的员工名单。
select a.Name as Employee
from Employee a inner join Employee b
on a.ManagerId = b.Id
and a.Salary > b.Salary
用inner join，输出符合要求的员工名单。
select a.Name as Employee
from Employee a inner join Employee b
on a.ManagerId = b.Id
and a.Salary > b.Salary
