leetcode 181 Employees Earning More Than Their Managers

最新推荐文章于 2020-05-10 01:57:55 发布

原创最新推荐文章于 2020-05-10 01:57:55 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一种SQL查询方法，用于从员工表中找出薪资高于其直接上级的员工。通过联接员工表自身的方式，对比员工薪资与其上级薪资，从而筛选出符合条件的记录。

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 |

+----------+

solution

select e1.Name from Employee e1,Employee e2 where e1.Salary>e2.Salary and e1.ManagerId=e2.Id