LeetCode Department Highest Salary
来源:互联网 发布:blackstone香烟淘宝店 编辑:程序博客网 时间:2024/06/07 01:56
The Employee
table holds all employees. Every employee has an Id, a salary, 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 |+----+-------+--------+--------------+
The Department
table holds all departments of the company.
+----+----------+| Id | Name |+----+----------+| 1 | IT || 2 | Sales |+----+----------+
Write a SQL query to find employees who have the highest salary in each of the departments. For the above tables, Max has the highest salary in the IT department and Henry has the highest salary in the Sales department.
+------------+----------+--------+| Department | Employee | Salary |+------------+----------+--------+| IT | Max | 90000 || Sales | Henry | 80000 |+------------+----------+--------+
select p.department as Department, e2.name as Employee, p.salary from ( select d.name as department, d.id as departmentid, max(e1.salary) as salary from Employee e1, Department d where e1.departmentid = d.id group by d.name, d.id) as p, Employee e2 where e2.departmentid = p.departmentid and e2.salary = p.salary;
0 0
- LeetCode:Department Highest Salary
- Leetcode: Department Highest Salary
- LeetCode Department Highest Salary
- [Leetcode]Department Highest Salary
- Leetcode: Department Highest Salary
- [LeetCode][Database]Department Highest Salary
- Database LeetCode Department Highest Salary
- leetcode.184. Department Highest Salary
- Leetcode 184. Department Highest Salary
- Leetcode 184. Department Highest Salary
- [LeetCode] Department Highest & Top 3 Salary - SQL
- [LeetCode]Department Highest Salary,解题报告
- 【leetcode Database】184. Department Highest Salary
- 【LeetCode】Department Highest Salary && Department Top Three Salaries
- Department Highest Salary
- Department Highest Salary
- Department Highest Salary
- Department Highest Salary
- PK 自解压软件 overwrite
- 第五周 项目2 对象作为成员函数
- object pool【上】
- 黑马程序员_类型信息
- LDA文本建模(2)——MCMC和Gibbs Sampling
- LeetCode Department Highest Salary
- 鸡尾酒排序简单随笔
- Java EE基础学习总结(一、JSP基础语法)
- Requset防盗链
- Android 使用Selector
- 黑马程序员——多线程
- TC TCO2015R1A(Similars-状态压缩)
- apache正常启动但无法访问localhost
- 使用joint.js 绘制图