MySQL-Employees Earning More Than Their Managers
来源:互联网 发布:有人打电话说淘宝退款 编辑:程序博客网 时间:2024/05/21 08:59
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 |+----------+
此题很简单,意思是要找出所有薪水比自己经理挣得多的员工,
# Write your MySQL query statement belowselect E1.Name Employee from Employee E1 join Employee E2 on E1.ManagerId = E2.Id where E1.Salary>E2.Salary order by E1.Id;
0 0
- MySQL-Employees Earning More Than Their Managers
- 题目6: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
- java注解机制详解
- Android 不要错过的 7 个完整项目学习
- tomcat fail to start
- 图片上传的跨域问题的几种解决方案和细节及优缺点
- int和Integer的区别
- MySQL-Employees Earning More Than Their Managers
- listview在有headerView的时候自动定位到第一项
- AngularJS2 学习(一)---学习前提
- 一些提高效率的技巧或思路(不定时更新)
- Freeline
- PAT-1127. ZigZagging on a Tree (30)
- 基于redis的消息队列
- Ionic集成ionic-datepicker插件
- PL/SQL 工具和免安装Oracle客户端连接远程数据库