181. 超过经理收入的员工

181. 超过经理收入的员工

where 连接

select a.Name as Employee from Employee as a, Employee as b
where a.ManagerId = b.Id and a.Salary > b.Salary;

join 连接

select a.Name as Employee
from Employee as a join Employee as b
on a.ManagerId = b.Id and a.Salary > b.Salary;