LeetCode--181. Employees Earning More Than Their Managers
来源:互联网 发布:阿里云ecs管理终端 编辑:程序博客网 时间:2024/06/10 22:42
Problem:
The Employee table holds all employees including their managers.
Every employee has an Id, and there is also a column for the managerId.
+----+-------+--------+-----------+| 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 |+----------+
Analysis:
这个题计较简单,主要用到内连接join的思想。
Answer:
#用join内连接# Write your MySQL query statement belowselect e1.name from Employee e1join Employee e2 on e1.ManagerId=e2.Idwhere e1.Salary>e2.Salary;
或者
#用where# Write your MySQL query statement belowselect e1.name from Employee e1,Employee e2 where e1.ManagerId=e2.Idand e1.Salary>e2.Salary;
0 0
- 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
- leetcode.181. Employees Earning More Than Their Managers
- [leetcode] 181. Employees Earning More Than Their Managers
- 【leetcode Database】181. Employees Earning More Than Their Managers
- leetcode 181. Employees Earning More Than Their Managers
- Leetcode 181. Employees Earning More Than Their Managers
- Android性能调优利器StrictMode
- 奇异值分解
- JAVA面试题
- leetcode 每日一题 169. Majority Element
- UVA12299 线段树水水水,但别乱开空间= =
- LeetCode--181. Employees Earning More Than Their Managers
- android项目的文件介绍
- function,procedure(异常处理)
- java设计模式——创建型之建造者模式
- iOS collectionView的多选---类似照片里的多选
- 欢迎使用CSDN-markdown编辑器
- HDOJ 1009 FatMouse' TradeD
- Linq to sql 笔记
- 开始吧,骚年