leetcode 185. Department Top Three Salaries
来源:互联网 发布:淘宝steam 编辑:程序博客网 时间:2024/05/16 09:40
185. Department Top Three Salaries
- Total Accepted: 7471
- Total Submissions: 49037
- Difficulty: Hard
The Employee
table holds all employees. Every employee has an Id, and there is also a column for the department Id.
+----+-------+--------+--------------+| Id | Name | Salary | DepartmentId |+----+-------+--------+--------------+| 1 | Joe | 70000 | 1 || 2 | Henry | 80000 | 2 || 3 | Sam | 60000 | 2 || 4 | Max | 90000 | 1 || 5 | Janet | 69000 | 1 || 6 | Randy | 85000 | 1 |+----+-------+--------+--------------+
The Department
table holds all departments of the company.
+----+----------+| Id | Name |+----+----------+| 1 | IT || 2 | Sales |+----+----------+
Write a SQL query to find employees who earn the top three salaries in each of the department. For the above tables, your SQL query should return the following rows.
+------------+----------+--------+| Department | Employee | Salary |+------------+----------+--------+| IT | Max | 90000 || IT | Randy | 85000 || IT | Joe | 70000 || Sales | Henry | 80000 || Sales | Sam | 60000 |+------------+----------+--------+
Subscribe to see which companies asked this question
# Write your MySQL query statement belowselect d.Name as Department, e.Name as Employee, e.Salary as Salary from Employee e inner join Department d on e.DepartmentId = d.Id where 3>(select count(distinct e1.Salary) from Employee e1 where e1.Salary>e.Salary and e1.DepartmentId = e.DepartmentId)
0 0
- LeetCode 185. Department Top Three Salaries
- leetcode-database-185. Department Top Three Salaries
- leetcode 185. Department Top Three Salaries
- 【leetcode Database】185. Department Top Three Salaries
- leetcode 185. Department Top Three Salaries
- [leetcode] Department Top Three Salaries
- LeetCode Department Top Three Salaries
- 185. Department Top Three Salaries
- Department Top Three Salaries
- Department Top Three Salaries
- [LeetCode][Database]Department Top Three Salaries
- leetcode 184,185 Department Top Three Salaries/HIGHEST Salaries
- 【LeetCode】Department Highest Salary && Department Top Three Salaries
- leetcode数据库sql之Department Top Three Salaries
- LeetCode_OJ【185】Department Top Three Salaries
- 题目9:MySQL---------Department Top Three Salaries
- [LeetCode] Department Highest & Top 3 Salary - SQL
- LeetCode:Department Highest Salary
- eclipse打包apk时遇到的问题
- 直播系统的准备工作-android版开源播放器ijkplayer
- 理解Fragment生命周期
- Java compiler level does not match解决方法
- Android进程间通信(IPC)
- leetcode 185. Department Top Three Salaries
- Java图形用户接口
- play framework自定义标签
- C\C++ 快速排序
- 剑指offer(1)
- 天易40----Myeclipse创建maven web项目
- listview的item中edittext与进度条出现问题的解决办法;
- UVA 11178 Morley's Theorem 计算几何
- Android自适应屏幕大小和layout布局(横屏|竖屏)