Leetcode笔记:(MySQL)181. Employees Earning More Than Their Managers
来源:互联网 发布:超级seo 编辑:程序博客网 时间:2024/06/09 20:32
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 |+----------+
My Solution:
SELECT b. NAME AS EmployeeFROM employee aLEFT JOIN employee b ON a.Id = b.ManagerIdWHERE a.Salary < b.Salary
思路:
先把Employee
表中有上司的员工的员工工资信息与上司工资信息连接在同一条记录内,再在同一条记录内比较工资高低。 (应使用inner join
)
要注意连接后员工信息Employee
表以及上司信息Employee
表的别名区分。此处a表为上司表,b表为员工表。
Other People’s Solutions:
Select emp.Name fromEmployee emp inner join Employee manageron emp.ManagerId = manager.Idwhere emp.Salary > manager.Salary
摘自 —— https://discuss.leetcode.com/topic/8315/sharing-my-solution/2
作者:mahdy
延伸:
SQL中inner join、outer join和cross join的区别 - This is bill的专属博客 - CSDN博客
http://blog.csdn.net/scythe666/article/details/51881235
阅读全文
1 0
- Leetcode笔记:(MySQL)181. Employees Earning More Than Their Managers
- Leetcode: Employees Earning More Than Their Managers
- leetcode: Employees Earning More Than Their Managers
- 【Leetcode】Employees Earning More Than Their Managers
- MySQL-Employees Earning More Than Their Managers
- 【MySQL】【leetcode】 Employees Earning More Than Their Managers解题报告
- LeetCode 181 -Employees Earning More Than Their Managers ( MYSQL )
- [Leetcode] [Database] 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
- iOS判断是两个日期是否大于1天
- 建立一个链表,每个结点数据包括:学号、姓名,性别、年龄。输入一个年龄,如果链表中的结点所包含的年龄等于此年龄,则将此结点删去。
- java解析xml并把节点值存储到数据库中
- 滚动切换选项卡视图
- redis集群的Cluster方式配置以及spring的集成
- Leetcode笔记:(MySQL)181. Employees Earning More Than Their Managers
- the specified license key not be verified as belonging to this host
- <C语言>实现输入几个数,先倒叙排列,再用“冒泡排序”方法从小到大排列
- 深度学习笔记——理论与推导之Structured Learning【Markov Logic Network】(十一)
- linux网络编程-UDP实现文件的传输
- 【转载】Android Studio NDK 开发与调试(生成 .so 文件)
- qduoj water problem(线段树)
- The container 'Maven Dependencies' references non existing library '
- Shader 标准贴图代码参考笔记