The Employee table holds all employees including their managers.
Every employee has an Id, and there is also a column for the manager
Id.
Id
Name
Salary
ManagerId
1
Joe
70000
3
2
Henry
80000
4
3
Sam
60000
NULL
4
Max
90000
NULL
Given the Employee table, write a SQL query that finds out employees
who earn more than their managers. For the above table, Joe is the only
employee who earns more than his manager.
Employee
Joe
题解
1 2 3 4
# Write your MySQL query statement below SELECT s1.Name Employee FROM Employee s1 , Employee s2 WHERE s1.ManagerId=s2.Id AND s1.Salary>s2.Salary;