题目6:MySQL----------Employees Earning More Than Their Managers
来源:互联网 发布:淘宝网店销赃案例 编辑:程序博客网 时间:2024/06/14 02:12
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.Name from Employee a,Employee b where a.ManagerId = b.Id and a.Salary > b.Salary;
0 0
- 题目6:MySQL----------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 )
- 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
- PC获取手机截图、复制文件、安装APK
- tomcat结合Java定时任务工具实现web中的定时任务
- Oracle:数据库原理
- 完美素数
- Ubuntu下Samba配置
- 题目6:MySQL----------Employees Earning More Than Their Managers
- Android 分享一个流量显示界面
- JFileChooser选择文件夹
- 题目7:MySQL----------Duplicate Emails
- 煞笔题
- SQLServer分析函数 (又称窗口函数)
- ResourceID(frameworks/base/libs/utils/README)
- Struts2中action接收参数的三种方法及ModelDriven跟Preparable接口结合JAVA反射机制的灵活用法
- 题目7:MySQL----------Customers Who Never Order