[Leetcode]Department Highest Salary
来源:互联网 发布:动物之间 感情 知乎 编辑:程序博客网 时间:2024/06/07 02:33
Department Highest Salary
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 |+------------+----------+--------+
1.
- select d.Name as Department, e.Name as Employee, e.Salary as Salary
- from Employee e, Department d ,
- (select DepartmentId ,MAX(Salary) as Salary from Employee group by DepartmentId ) t
- where e.DepartmentId=t.DepartmentId and e.Salary=t.Salary and d.Id=e.DepartmentId;
2.
# Write your MySQL query statement below
SELECT d.Name AS Department, e.Name AS Employee, t.Salary
FROMEmployee e
INNER JOIN (SELECT DepartmentId, MAX(Salary)
AS Salary FROM Employee GROUP BY DepartmentId) t
USING(DepartmentId, Salary)
INNER JOIN Department d
ON d.id = t.DepartmentId
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
- 《C++ primer》ch6 switch语句
- Binder service入门–创建native binder service
- 从零入手Kinetis系统开发(四)之启动代码分析
- centos6.x忘记root密码解决方法
- 性能调优思考
- [Leetcode]Department Highest Salary
- JVM 参数大全
- VTKBoundaryEdges的四种情况分析
- Java 中的引号问题
- eclipse下导入jdk源码
- 实例说明MapReduce原理
- Tomcat 映射虚拟目录
- 搞ACM的伤不起啊
- C盘ProgramData变得巨大--VS2010在C盘下生成的.iTrace文件解决办法