leetcode/en/lc/184/

[giscus[bot]]

leetcode/en/lc/184/

LeetCode solutions in any programming language

https://doocs.github.io/leetcode/en/lc/184/

[luckykumar22]

SELECT Department.name AS Department ,Employee.name AS Employee, Employee.salary
FROM Department JOIN Employee ON Employee.departmentId=Department.id
WHERE(departmentId, salary) IN
(SELECT departmentId,MAX(salary) FROM Employee GROUP BY departmentId) ;