184. Department Highest Salary
```\nSELECT dept.Name AS Department, Employee.Name AS Employee, Salary\nFROM Employee\n\nINNER JOIN Department AS dept ON Employee.DepartmentId=dept.Id\n\nwhere
```\nSELECT dept.Name AS Department, Employee.Name AS Employee, Salary\nFROM Employee\n\nINNER JOIN Department AS dept ON Employee.DepartmentId=dept.Id\n\nwhere (dept.Id, Salary) IN (SELECT DepartmentId, max(Salary)\n                         FROM Employee GROUP BY DepartmentId);
['MySQL']