leetcode 181. Employees Earning More Than Their Managers
来源:互联网 发布:冰点文库软件下载 编辑:程序博客网 时间:2024/06/05 05:25
181. Employees Earning More Than Their Managers
- 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 belowselect e.Name as Employeefrom Employee e, Employee e1 where e.ManagerId = e1.Id and e.Salary > e1.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
- 在iOS开发中使用FMDB
- PL/SQL 常用字符类函数
- 用mingw编译ffmpeg
- Java 集合框架源码分析(二)——LinkedList
- java题库10
- leetcode 181. Employees Earning More Than Their Managers
- Java总结系列之正则表达式
- jqgrid表格单双行样式不同
- Qt creator needs a compiler set up to build. Configure a compiler in the kit options
- HDOJ 1068 Girls and Boys (最大匹配数 匈牙利算法)
- 多校6 A Boring Question 5793
- 获取linux服务器性能CPU、内存、硬盘等使用率 PHP
- git rebase后commit丢失
- Linux系统自带SPI接口驱动自测