184. Department Highest Salary
来源:互联网 发布:电子商务美工方向 编辑:程序博客网 时间:2024/05/17 07:16
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 |+------------+----------+--------+
Subscribe to see which companies asked this question.
MySQL:
# Write your MySQL query statement belowselect dd.Department as Department, ee.Name as Employee, dd.Salary as Salaryfrom Employee ee, ( select max(e.DepartmentId) as DepartmentId, d.Name as Department, max(e.Salary) as Salary from Employee e, Department d where e.DepartmentId = d.Id group by d.Name ) ddwhere ee.Salary = dd.Salary and ee.DepartmentId = dd.DepartmentId;
0 0
- 184. Department Highest Salary
- 184. Department Highest Salary
- 184. Department Highest Salary
- 184. Department Highest Salary
- leetcode.184. Department Highest Salary
- Leetcode 184. Department Highest Salary
- Leetcode 184. Department Highest Salary
- 184. Department Highest Salary#1
- 【leetcode Database】184. Department Highest Salary
- LeetCode:Department Highest Salary
- Leetcode: Department Highest Salary
- LeetCode Department Highest Salary
- [Leetcode]Department Highest Salary
- Department Highest Salary
- Leetcode: Department Highest Salary
- Department Highest Salary
- Department Highest Salary
- Department Highest Salary
- 【整理收集】那些神器级别的BT磁力搜索网站
- Lua-nginx-module的安装
- HTML(3)——<br/>拆行
- 【Oracle】PL/SQL——游标CURSOR
- 【C++学习笔记】延时循环
- 184. Department Highest Salary
- ffmpeg--学习笔记3-学习1-ffmpeg命令行参数
- RabbitMQ+PHP 消息队列环境配置
- 成功 or 改变
- 利用自动索引计算数组元素平方和
- Fizz Buzz问题及解法
- [sklearn学习]linear_model.LinearRegression
- [转]手工开栈
- Servlet学习笔记