select a.Name as Employee from Employee a join Employee b On a.ManagerId = b.Id where a.Salary > b.Salary;
直接写也行
SELECT e1.Name FROM Employee e1, Employee e2 WHERE e1.ManagerId = e2.Id AND e1.Salary > e2.Salary;
本文共 262 字，大约阅读时间需要 1 分钟。
select a.Name as Employee from Employee a join Employee b On a.ManagerId = b.Id where a.Salary > b.Salary;
直接写也行
SELECT e1.Name FROM Employee e1, Employee e2 WHERE e1.ManagerId = e2.Id AND e1.Salary > e2.Salary;
转载于:https://www.cnblogs.com/willaty/p/8379906.html