Employees Earning More Than Their Managers
来源:互联网 发布:php数组90度旋转 编辑:程序博客网 时间:2024/06/03 10:03
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 |+----------+
answer:select a.Name as Employee from Employee a where a.Salary > (select b.Salary from Employee b where b.Id = a.ManagerId)
0 0
- 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
- 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
- MySQL-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
- JavaScript随机产生文字实例
- How-to Dump Keys from Memcache
- 服务器安全部署文档
- C/C++中函数参数传递详解
- leetcode--Unique Binary Search Trees
- Employees Earning More Than Their Managers
- php 把“今天”作为查询条件
- 关于composer.json的格式问题
- 程序员技术练级攻略
- Qt控制台不能调试Cannot connect creator comm.....
- Source code manager common
- android 捕获返回(后退)按钮事件的两种方法
- JAVA- Thread初步
- 多线程安全琐碎