- 题目描述
- 解法代码
SELECT E1.Name AS Employee
FROM Employee AS E1,Employee AS E2
WHERE E1.ManagerId=E2.Id AND E1.Salary>E2.Salary;
- SQL知识点
自联结
SELECT E1.Name AS Employee
FROM Employee AS E1,Employee AS E2
WHERE E1.ManagerId=E2.Id AND E1.Salary>E2.Salary;