leetcode 181. Employees Earning More Than Their Managers

客官°小女子只卖身不卖艺 2022-07-19 01:56 49阅读 0赞

### 181. Employees Earning More Than Their Managers ###

Question Editorial Solution

[My Submissions][]

*  Total Accepted: 23223
 *  Total Submissions: 61926
 *  Difficulty: Easy

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

# Write your MySQL query statement below
    select e.Name as Employee
    from Employee e, Employee e1 
    where e.ManagerId = e1.Id and e.Salary > e1.Salary ;

[My Submissions]: https://leetcode.com/problems/employees-earning-more-than-their-managers/submissions/
[Subscribe]: https://leetcode.com/subscribe/

发表评论取消回复

表情：

评论列表（有 0 条评论，49人围观）

还没有评论，来说两句吧...

相关阅读

相关 Using WebView from more than one process

今天遇到一个线上问题，启动就闪退，比较坑，在此做一个记录，防止掉坑。本文记录一次bug解决的过程，Using WebView from more than one pro...

谁践踏了优雅/ 2024年05月28日 10:01/ 0 赞/ 63 阅读

相关 LeetCode 596. Classes More Than 5 Students (超过5名学生的课)

题目标签：　　题目给了我们 courses 表格，让我们找到一个有至少5名学生的班级。　　利用group by 把班级分类，在用Having count 来判断是否有

￡神魔★判官ぃ/ 2023年08月17日 16:45/ 0 赞/ 74 阅读

相关 LeetCode 181. Employees Earning More Than Their Managers (超过经理收入的员工)

题目标签：　　题目给了我们一个员工表，包括经理。员工会有经理的id。　　这里可以重复利用两次表格，表格a，表格b，当a 员工的经理id 等于 b员工时候，在从

红太狼/ 2023年08月17日 16:45/ 0 赞/ 116 阅读

相关 OpenKruise 2021 规划曝光：More than workloads

![头图.png][.png] 作者 | 王思宇（酒祝）来源|[阿里巴巴云原生公众号][Link 1] 背景 > OpenKruise 项目地址：[https:

女爷i/ 2023年01月02日 09:29/ 0 赞/ 112 阅读

相关 LeetCode - Easy - 181. Employees Earning More Than Their Managers

Topic SQL Description [https://leetcode.com/problems/employees-earning-more-th

淡淡的烟草味﹌/ 2022年12月29日 12:54/ 0 赞/ 103 阅读

相关【leetcode Database】181. Employees Earning More Than Their Managers

题目： The `Employee` table holds all employees including their managers. Every employee h

叁歲伎倆/ 2022年09月24日 06:21/ 0 赞/ 120 阅读

相关【MySQL】【leetcode】 Employees Earning More Than Their Managers解题报告

题目 The Employee table holds all employees including their managers. Every employee ha

爱被打了一巴掌/ 2022年08月09日 09:59/ 0 赞/ 131 阅读

相关 leetcode 181. Employees Earning More Than Their Managers

181. Employees Earning More Than Their Managers Question Editorial Solution [My Subm

客官°小女子只卖身不卖艺/ 2022年07月19日 01:56/ 0 赞/ 50 阅读

相关 TRIPLE is More Than DOUBLE Plus One

https://techsingular.org/2017/12/29/triple-is-more-than-double-plus-one/ TRIPLE i

淩亂°似流年/ 2022年06月01日 06:36/ 0 赞/ 142 阅读

相关 #Leetcode# 596. Classes More Than 5 Students

[https://leetcode.com/problems/classes-more-than-5-students/][https_leetcode.com_problem

旧城等待，/ 2021年11月09日 23:30/ 0 赞/ 228 阅读