LeetCode 181 -Employees Earning More Than Their Managers ( MYSQL )
来源:互联网 发布:淘宝网官方网站电脑版 编辑:程序博客网 时间:2024/06/10 19:45
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 |+----------+
# Write your MySQL query statement belowselect b.Name from Employee a, Employee b where a.Id = b.ManagerId and b.Salary > a.Salary;
总结:应该算是自连接吧,sql 好久没写了,有点生疏了都。主要注意a,b的属性的引用。
1 0
- LeetCode 181 -Employees Earning More Than Their Managers ( MYSQL )
- Leetcode: Employees Earning More Than Their Managers
- leetcode: Employees Earning More Than Their Managers
- 【Leetcode】Employees Earning More Than Their Managers
- MySQL-Employees Earning More Than Their Managers
- 【MySQL】【leetcode】 Employees Earning More Than Their Managers解题报告
- 181 Employees Earning More Than Their Managers
- leetcode 181 Employees Earning More Than Their Managers
- Employees Earning More Than Their Managers Leetcode SQL
- 【leetcode SQL】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解题笔记
- Database LeetCode Employees Earning More Than Their Managers
- LeetCode:181. Employees Earning More Than Their Managers
- LeetCode--181. Employees Earning More Than Their Managers
- Spark 提供的概率与统计算法 - 基本统计算法
- nyoj 91
- SEVERE: Error configuring application listener of class org.springframework.web.context.ContextLoade
- C++学习 之感
- LeetCode——018
- LeetCode 181 -Employees Earning More Than Their Managers ( MYSQL )
- 5个JavaScript库
- 面试总结 —— 高级JAVA工程师
- nodejs npm常用命令
- 阻止a标签默认行为的几种简单方法
- Big Code简介
- CodeForces 235B Let's Play Osu!
- 推荐一个背景建模的开源库
- javascript将页尾悬置在页面底部