LeetCode——Employees Earning More Than Their Managers
2024-10-20 03:05:11
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 |
+----------+
这种单表比较条件,一般都是表内进行join
操作.
参照此思路,解题如下所示:
# Write your MySQL query statement below
SELECT
a.Name AS Employee
FROM Employee a, Employee b
WHERE
a.ManagerId = b.Id
AND a.Salary > b.Salary;
运行效率在可以接受的范围,此外语句也较为清晰便于维护.
最新文章
- redis事务详解
- 转载文章----C#基础概念
- 线段树——Ultra-QuickSort
- Jquery easyui的validatebox控件和正则表达式
- 使用codeblock实现JNI开发-2016.01.31
- 使用ssh公钥密钥自动登陆linux服务器
- levelDB缓存实现
- JObject对json的操作
- vue集成环信IM
- Windows文件系统
- u3d内嵌H5游戏 设置cookie
- 重磅:Spring Boot 2.0 正式发布!
- MongoDB shell 介绍
- Emacs常用基本操作
- Git合并最近的commit
- linux(ubuntu)下安装phantomjs
- UVaLive 3357 Pinary (Fib数列+递归)
- C++ —— 重载、覆盖和隐藏
- pwd、ln和重定向命令
- Beta冲刺一《WAP团队》