https://leetcode.com/problems/department-highest-salary/
Department Highest Salary - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
|
SELECT D.name AS Department, E.name AS Employee, E.salary
FROM Department AS D
INNER JOIN Employee AS E
ON D.id = E.departmentId
WHERE (E.salary, E.departmentID) IN (
SELECT MAX(EE.salary), EE.departmentId
FROM Employee AS EE
GROUP BY EE.departmentId
)
|
cs |
'Leetcode' 카테고리의 다른 글
| [LeetCode] 15. 3sum [C/C++] Two Pointer (0) | 2022.06.19 |
|---|---|
| LeetCode 181. Employees Earning More Than Their Managers [MySql] (0) | 2022.06.03 |
| LeetCode 180. Consecutive Numbers [MySql] (0) | 2022.06.03 |
| LeetCode 178. Rank Scores [MySql] (0) | 2022.06.03 |
| LeetCode 1115. Print FooBar Alternately [C++/ promise] (0) | 2022.06.03 |