Database LeetCode Employees Earning More Than Their Managers
来源:互联网 发布:网络教育毕业容易吗 编辑:程序博客网 时间:2024/06/02 17:33
题目:
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 |
+----------+
题意:
给定上述的一个数据表,要求写一个SQL的查询语句,找出那些赚得比他们的经理工资要多的员工的姓名。
题解:
此题考虑用连接来做。可以将一张表格考虑成两张表格来做,然后用内连接的不等值连接来取得相应的结果;这里有一个需要注意的地方:在输出的时候,需要将姓名的列名改为Employee。
select e.Name as Employee from Employee as e join Employee as x on e.ManagerId = x.Id and e.Salary >= x.Salary;
还有一种是用自连接来做:
select e.name as 'Employee' from Employee e,Employee m where e.managerid=m.id and e.salary>m.salary;
0 0
- [LeetCode][Database]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 Database】181. Employees Earning More Than Their Managers
- Leetcode: Employees Earning More Than Their Managers
- leetcode: Employees Earning More Than Their Managers
- 【Leetcode】Employees Earning More Than Their Managers
- LeeCode(Database)-Employees Earning More Than Their Managers
- Employees Earning More Than Their Managers Leetcode SQL
- leetcode 181 Employees Earning More Than Their Managers
- 【leetcode SQL】Employees Earning More Than Their Managers
- LeetCode OJ Employees Earning More Than Their Managers
- [LeetCode]Employees Earning More Than Their Managers,解题报告
- 【MySQL】【leetcode】 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 ( MYSQL )
- Hadoop是怎么分块的
- POJ1017 - Packets(模拟)
- C#程序命令行 提示csc、ildasm C#命令不是内部或外部命令
- perl-引用,没有理太多理论,都是案例
- Java API读写HDFS。
- Database LeetCode Employees Earning More Than Their Managers
- MPV播放器使用手册
- CenOS6.5安装JDK1.7
- LeetCode3:Longest Substring Without Repeating Characters
- 【委托】—是什么&怎么用&什么用
- POJ 1064 Cable master
- windows多线程同步机制---互斥量
- MySQL limit分页查询优化写法
- java 程序中try catch / throw / 函数名上throws 具体执行顺序和扔异常捕获异常的概念模型