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

叁歲伎倆 2022-09-24 06:21 129阅读 0赞

题目：

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      |
    +----------+

解析：本题可以使用自连接来做。声明Employee表的两个别名e1和e2，然后select e1的ManagerId字段与e2的Id字段相等，且e1的Salary大于e2的Salary。代码如下：

# Write your MySQL query statement below
    SELECT e1.Name AS Employee FROM Employee AS e1,Employee AS e2 WHERE e1.ManagerId = e2.Id AND e1.Salary > e2.Salary;

发表评论取消回复

表情：

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

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

相关阅读

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

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

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

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

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

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

相关 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 赞/ 124 阅读

相关【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 赞/ 130 阅读

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

Problem: > The Employee table holds all employees including their managers. > Every e

Myth丶恋晨/ 2022年08月21日 01:08/ 0 赞/ 9 阅读

相关【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 赞/ 148 阅读

相关 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 赞/ 62 阅读

相关 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 赞/ 159 阅读

相关 #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 赞/ 242 阅读

相关 Postgres Database management operations

　　1. Scanning tables It is a leanear operation which can fetch data block c

╰半夏微凉°/ 2021年10月19日 15:00/ 0 赞/ 257 阅读