181. Employees Earning More Than Their Managers--自连接
来源:互联网 发布:怎么用淘宝注册支付宝 编辑:程序博客网 时间:2024/05/20 16: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 |+----------+
这个解决方法好像是叫自连接?
select E1.Name from Employee as E1, Employee as E2 where E1.ManagerId = E2.Id and E1.Salary > E2.Salary
评论里说内连接的速度可以快一点
select a.Namefrom Employee a inner join Employee b on a.ManagerId=b.Idwhere a.Salary>b.Salary
SELECT e1.`Name`FROM `Employee` e1 LEFT JOIN `Employee` e2 ON (e2.`Id` = e1.`ManagerId`)WHERE e1.`ManagerId` IS NOT NULL AND e1.`Salary` > e2.`Salary`事实上inner join已经做到这一点了
INNER JOIN 关键字在表中存在至少一个匹配时返回行。
拓展阅读:
sql内连接、外连接和自连接查询
http://blog.csdn.net/zdp072/article/details/42458569
阅读全文
0 0
- 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
- 181. Employees Earning More Than Their Managers
- Employees Earning More Than Their Managers
- Employees Earning More Than Their Managers
- Leetcode: Employees Earning More Than Their Managers
- Employees Earning More Than Their Managers
- leetcode: Employees Earning More Than Their Managers
- Employees Earning More Than Their Managers
- leetcode181-Employees Earning More Than Their Managers
- 【Leetcode】Employees Earning More Than Their Managers
- SQL-Employees Earning More Than Their Managers
- 181 Employees Earning More Than Their Managers
- ubuntu打印设置
- 你还需要什么来管理自己的数据?
- 简述Spring容器与SpringMVC的容器的联系与区别
- adb查看内核LOG信息
- 基于Unity3D平台的三维虚拟城市研究与应用
- 181. Employees Earning More Than Their Managers--自连接
- document.location和window.location有什么区别
- 内存管理(Linux内核源码分析)
- 密码学笔记2 数论之趣
- Java简介
- R
- 泛型限制基础
- JS调用天气其他杂谈
- Elasticsearch中扫描和滚动处理深分页问题