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; 

 

posted on 2021-08-20 16:39  一仟零一夜丶  阅读(34)  评论(0)    收藏  举报