184. Department Highest Salary
这道题相对比较复杂，但是很典型，首先我们确定的是需要联结两个表，而且还需要使用GROUP BY语句确定每个部门中的MAX(Salary)。见题解。
# Write your MySQL query statement below
SELECT D.Name AS Department, E.Name AS Employee, Salary
FROM Department D INNER JOIN Employee E ON D.Id = E.DepartmentId
WHERE (E.DepartmentId, Salary) IN
(SELECT DepartmentId, Max(Salary) FROM Employee GROUP BY DepartmentId);
LeetCode 184. Department Highest Salary 题目 The Employee t...
The Employeetable holds all employees. Every employee has...
题目链接： 184. Department Highest Salary 解析： 这道题相对比较复杂，但是很典型，...
本SQL问题是 #184. Department Highest Salary 问题 编写SQL，找出每个部门的最...
本SQL问题是 #184. Department Highest Salary 解决本地主要是利用了mysql 实...
类型一：按照某个组分类计算该组最高/最低的记录 Department Highest Salary 解法一： ...
ProblemWrite a SQL query to get the second highest salary...
Write a SQL query to get the nth highest salary from the ...
Write a SQL query to get the nth highest salary from the ...
日前，College degrees with the highest salary potential出炉，根据...
本文标题：184. Department Highest Salary
本文链接：https://www.haomeiwen.com/subject/jdbdmftx.html
网友评论