181. Employees Earning More Than Their Managers

SELECT e.Name AS Employee
FROM Employee e
INNER JOIN Employee m
ON e.ManagerId = m.Id AND e.Salary > m.Salary;

posted @ 2018-12-20 03:01  yuesi  阅读(119)  评论(0编辑  收藏  举报