【LeetCode】181. Employees Earning More Than Their Managers
来源:互联网 发布:淘宝店托管 编辑:程序博客网 时间:2024/05/21 19:45
1、题目要求: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.
解答:
1)SELECT e1.Name AS Employee
FROM Employee AS e1 INNER JOIN Employee AS e2
ON e1.ManagerId = e2.Id
WHERE e1.Salary > e2.Salary
2) 或者用两个条件进行过滤
SELECT a.NAME FROM Employee a, Employee b
WHERE a.ManagerId = b.Id AND a.Salary > b.Salary;
注,AS 用作别名,可写可不写。
阅读全文
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
- Javascript之BOM对象
- HTML学习笔记4 基础标签
- 第三周项目三
- 9-23NOIP模拟赛总结
- POJ 2752 Seek the Name, Seek the Fame(KMP next数组的应用)
- 【LeetCode】181. Employees Earning More Than Their Managers
- 支持向量机1
- ACM-ICPC国际大学生程序设计竞赛北京赛区(2017)网络赛 E.Territorial Dispute
- 简单创建多线程
- IDA快捷键
- MySQL理解索引、添加索引的原则
- Spring 集成 Jedis
- 6:ZigZag Conversion(锯齿形的转换)
- java的键盘录入