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  阅读(125)  评论(0)    收藏  举报