leetcode.181. Employees Earning More Than Their Managers
来源:互联网 发布:ubuntu文档 编辑:程序博客网 时间:2024/05/29 15:49
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 e.name as 'Employee' from Employee e,Employee m where e.managerid=m.id and e.salary>m.salary;
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
- Filthy Rich(动态规划)
- JS图片滚动代码(无缝、平滑)
- 获取当前城市
- WEB前端开发人员须知的常见浏览器兼容问题及解决技巧
- DBCP配置
- leetcode.181. Employees Earning More Than Their Managers
- HDU 1072 Nightmare
- saltstack学习汇总
- [李景山php]每天laravel-20160910|Filesystem-1
- POJ 1654 Area
- Js图片连续左右滚动
- Android Studio常用快捷键(持续更新)
- 点除与矩阵除法
- JS图片切换,带缩略图版