181. Employees Earning More Than Their Managers
来源:互联网 发布:java 线程 sleep 编辑:程序博客网 时间:2024/06/13 03: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 |+----------+
Subscribe to see which companies asked this question.
MySQL:
# Write your MySQL query statement belowselect a.Name as Employeefrom ( select Id, Name, Salary, ManagerId from Employee where ManagerId is not null ) ainner join Employee bon a.ManagerId = b.Idwhere a.Salary > b.Salary;
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
- 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
- MySQL-Employees Earning More Than Their Managers
- 175. Combine Two Tables
- IP地址,子网掩码,默认网关
- 免费wifi帮助文档
- C# 数据类型
- sdut 3469 深度优先搜索练习之神奇的矩环
- 181. Employees Earning More Than Their Managers
- Java初始化顺序
- Mysql中的联合索引、前缀索引、覆盖索引
- LIBSVM在Matlab下的使用
- python函数错误
- 腾讯课堂笔记day1+day2
- docker实用命令--未完待续
- 产品经理之互联网产品的常见商业模式
- java异常的总结