184. Department Highest Salary💰
\n# Code\n\n# Write your MySQL query statement below\nSELECT DEPT.name AS Department, EMP.name AS Employee, EMP.salary AS Salary \nFROM Department DEPT, Employe
\n# Code\n```\n# Write your MySQL query statement below\nSELECT DEPT.name AS Department, EMP.name AS Employee, EMP.salary AS Salary \nFROM Department DEPT, Employee EMP WHERE\nEMP.departmentId = DEPT.id AND (EMP.departmentId, salary) IN \n(SELECT departmentId, MAX(salary) FROM Employee GROUP BY departmentId)\n```
['Database', 'MySQL']