leetcode SQL Employees Earning More Than Their Managers
来源:互联网 发布:2k16樱木花道捏脸数据 编辑:程序博客网 时间:2024/06/05 16:07
题目如下:
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 |+----------+
答案:
select e1.Name as Employee from Employee as e1,Employee as e2 where e1.Id = e2.ManagerId and e1.Salary>e2.Salary;
思路:由于这是在同一个表中对样本进行筛选,然后对不同列进行比较,因此最直观的方法是将Employee引申为两个表e1、e2,这样才能做出比较直观的筛选和比较操作。
阅读全文
0 0
- Leetcode: Employees Earning More Than Their Managers
- leetcode: Employees Earning More Than Their Managers
- 【Leetcode】Employees Earning More Than Their Managers
- SQL-Employees Earning More Than Their Managers
- Employees Earning More Than Their Managers Leetcode SQL
- 【leetcode SQL】Employees Earning More Than Their Managers
- [leetcode][SQL]181. Employees Earning More Than Their Managers
- leetcode SQL Employees Earning More Than Their Managers
- leetcode 181 Employees Earning More Than Their Managers
- [LeetCode][Database]Employees Earning More Than Their Managers
- LeetCode OJ Employees Earning More Than Their Managers
- [LeetCode]Employees Earning More Than Their Managers,解题报告
- 【Leetcode Database】Employees Earning More Than Their Managers
- [Leetcode] [Database] Employees Earning More Than Their Managers解题笔记
- 【MySQL】【leetcode】 Employees Earning More Than Their Managers解题报告
- Database LeetCode Employees Earning More Than Their Managers
- LeetCode:181. Employees Earning More Than Their Managers
- LeetCode--181. Employees Earning More Than Their Managers
- LeetCode-42:Trapping Rain Water
- 4.1.内存这个大话题
- 为Excel单元格后面统一添加一个字符,导Excel数据到数据库
- LeetCode 4. Median of Two Sorted Arrays
- Launcher拖拽框架
- leetcode SQL Employees Earning More Than Their Managers
- 程序员福利——几个不错的技术微信公众号
- MyBatis架包的下载地址和简介地址
- windows7 下nginx1.8.1(稳定版本) 启动、停止和重新加载配置
- 白盒测试方法以及归纳
- 进程通信方式--共享内存(shm)--实现自由通信
- linux系统虚拟鼠标的实现
- MySQL5.7密码安全策略
- 重写,重载