【leetcode Database】181. Employees Earning More Than Their Managers
来源:互联网 发布:淘淘商城 源码 编辑:程序博客网 时间:2024/06/04 19:58
题目:
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 |+----------+解析:本题可以使用自连接来做。声明Employee表的两个别名e1和e2,然后select e1的ManagerId字段与e2的Id字段相等,且e1的Salary大于e2的Salary。代码如下:
# Write your MySQL query statement belowSELECT e1.Name AS Employee FROM Employee AS e1,Employee AS e2 WHERE e1.ManagerId = e2.Id AND e1.Salary > e2.Salary;
0 0
- 【leetcode Database】181. Employees Earning More Than Their Managers
- [LeetCode][Database]Employees Earning More Than Their Managers
- 【Leetcode Database】Employees Earning More Than Their Managers
- [Leetcode] [Database] Employees Earning More Than Their Managers解题笔记
- Database LeetCode 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
- 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
- bnuoj_24430 Tiling
- UML建模学习6:Class Diagram(一)
- IDA学习笔记
- 极限学习机 Elm
- docker基本的使用命令总结
- 【leetcode Database】181. Employees Earning More Than Their Managers
- 我也要开始写博客,争取当一个技术大牛
- retrofit2+okhttp3+ rxjava 遇到的问题及解决方案
- 今天用Fragment,结果继承Fragment的类出现了replace始终报错的问题
- Android开发常见问题之Process 'command 'D:\Java Jdk\java\bin\java.exe'' finished with non-zero exit value 2
- Android adb 命令
- 尺追法
- react native第三方组件问题
- C# Oracle数据库操作类实例详解