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

爱被打了一巴掌 2022-08-09 09:59 145阅读 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.

<table> 
 <thead> 
  <tr> 
   <th align="left">Id</th> 
   <th align="left">Name</th> 
   <th align="left">Salary</th> 
   <th align="left">ManagerId</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td align="left">1</td> 
   <td align="left">Joe</td> 
   <td align="left">70000</td> 
   <td align="left">3</td> 
  </tr> 
  <tr> 
   <td align="left">2</td> 
   <td align="left">Henry</td> 
   <td align="left">80000</td> 
   <td align="left">4</td> 
  </tr> 
  <tr> 
   <td align="left">3</td> 
   <td align="left">Sam</td> 
   <td align="left">60000</td> 
   <td align="left">NULL</td> 
  </tr> 
  <tr> 
   <td align="left">4</td> 
   <td align="left">Max</td> 
   <td align="left">90000</td> 
   <td align="left">NULL</td> 
  </tr> 
 </tbody> 
</table>

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 below
    select e1.Name as Employee from Employee as e1, Employee as e2 where e1.ManagerId = e2.Id and e1.Salary > e2.Salary;

发表评论取消回复

表情：

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

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

相关阅读

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

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

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

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

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

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

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

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

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

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

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

相关 [解题报告]Feynman

题目大意题目原文：[http://uva.onlinejudge.org/external/121/12149.pdf][http_uva.onlinejudge

女爷i/ 2022年01月07日 12:51/ 0 赞/ 292 阅读

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