181. 超过经理收入的员工
SELECT `name` as Employee FROM Employee AS e1, #获取一个还有经理id和Salary的表 (SELECT id,Salary FROM Employee WHERE id IN (SELECT ManagerId FROM Employee WHERE ManagerId IS NOT NULL)) AS e2 WHERE e1.Salary >e2.Salary AND e1.ManagerId=e2.id;
SELECT `name` as Employee FROM Employee AS e1, #获取一个还有经理id和Salary的表 (SELECT id,Salary FROM Employee WHERE id IN (SELECT ManagerId FROM Employee WHERE ManagerId IS NOT NULL)) AS e2 WHERE e1.Salary >e2.Salary AND e1.ManagerId=e2.id;