en/lc/184/

[giscus[bot]]

en/lc/184/

LeetCode solutions in any programming language

https://leetcode.doocs.org/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) ;