LeetCode:181. Employees Earning More Than Their Managers
来源:互联网 发布:墓畔回忆录 知乎 编辑:程序博客网 时间:2024/06/11 01:17
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 |+----------+firstly,Select * From Employee a and Employee b,get the result as below
Noticed that in the last three columns the Id is equal to Joe's, Henery's id Sam's Id as described in this question we need to find a.manager id is equal to b.id,when meet this requirement we need to make our a.salary is larger than b.salary.
mysql> SELECT * FROM EMPLOYEE a,EMPLOYEE b;+----+--------+--------+-----------+----+--------+--------+-----------+| Id | Name | Salary | ManagerId | Id | Name | Salary | ManagerId |+----+--------+--------+-----------+----+--------+--------+-----------+| 1 | Joe | 70000 | 3 | 1 | Joe | 70000 | 3 || 2 | Henery | 80000 | 4 | 1 | Joe | 70000 | 3 || 3 | Sam | 60000 | NULL | 1 | Joe | 70000 | 3 || 4 | Max | 90000 | NULL | 1 | Joe | 70000 | 3 || 1 | Joe | 70000 | 3 | 2 | Henery | 80000 | 4 || 2 | Henery | 80000 | 4 | 2 | Henery | 80000 | 4 || 3 | Sam | 60000 | NULL | 2 | Henery | 80000 | 4 || 4 | Max | 90000 | NULL | 2 | Henery | 80000 | 4 || 1 | Joe | 70000 | 3 | 3 | Sam | 60000 | NULL || 2 | Henery | 80000 | 4 | 3 | Sam | 60000 | NULL || 3 | Sam | 60000 | NULL | 3 | Sam | 60000 | NULL || 4 | Max | 90000 | NULL | 3 | Sam | 60000 | NULL || 1 | Joe | 70000 | 3 | 4 | Max | 90000 | NULL || 2 | Henery | 80000 | 4 | 4 | Max | 90000 | NULL || 3 | Sam | 60000 | NULL | 4 | Max | 90000 | NULL || 4 | Max | 90000 | NULL | 4 | Max | 90000 | NULL |+----+--------+--------+-----------+----+--------+--------+-----------+
the result is
SELECT * From Employee a,Employee b
WHERE a.managerId = b.Id AND a.Salary>b.Salary
0 0
- Leetcode: Employees Earning More Than Their Managers
- leetcode: Employees Earning More Than Their Managers
- 【Leetcode】Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- 181. Employees Earning More Than Their Managers
- LeetCode:181. Employees Earning More Than Their Managers
- LeetCode--181. Employees Earning More Than Their Managers
- leetcode 181. Employees Earning More Than Their Managers
- leetcode.181. Employees Earning More Than Their Managers
- [leetcode] 181. Employees Earning More Than Their Managers
- 【leetcode Database】181. Employees Earning More Than Their Managers
- leetcode 181. Employees Earning More Than Their Managers
- Leetcode 181. Employees Earning More Than Their Managers
- LeetCode OJ刷题历程——Two Sum
- filter过滤器
- Debian/Ubutun 之 桌面自定义
- 飞机大战
- python学习常用网站
- LeetCode:181. Employees Earning More Than Their Managers
- VMware-workstation中文版修改成英文版简单方法
- Android应用启动优化:一种DelayLoad的实现和原理
- linux的帮助命令
- java文档的简单加密与解密
- iOS开发中 色值 16进制相互转换 详细RGB值
- Android开发中一些被冷落但却很有用的类和方法
- [转]android界面的美化shape的使用
- Bruce Lee--自我认识