描述
The Employee
table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.
1 | +----+-------+--------+-----------+ |
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.
1 | +----------+ |
分析
找出工资比他的 Manager 还要高的职员
解决方案(MySQL)
1 | # Write your MySQL query statement below |