181超过经理收入的员工
程序员文章站
2022-03-13 21:26:07
...
SELECT a.Name AS Employee FROM Employee AS a, Employee AS b
WHERE a.ManagerId = b.Id
and a.Salary > b.Salary
SELECT a.Name AS Employee FROM Employee AS a JOIN Employee AS b ON
a.ManagerId = b.Id
and a.Salary > b.Salary