SELECT Department.name AS'Department', Employee.name AS'Employee', SalaryFROM EmployeeJOIN Department ON Employee.DepartmentId = Department.IdWHERE (Employee.DepartmentId , Salary) IN ( SELECT DepartmentId, MAX(Salary)FROM EmployeeGROUP BY DepartmentId );
SELECT d.Name AS Department, e1.Name AS Employee, e1.Salary FROM Employee e1JOIN Department d ON e1.DepartmentId = d.Id WHERE Salary IN (SELECTMAX(Salary) FROM Employee e2 WHERE e1.DepartmentId = e2.DepartmentId);
SELECT d.Name AS Department, e.Name AS Employee, e.Salary FROM Employee e, Department dWHERE e.DepartmentId = d.Id AND e.Salary = (SELECTMAX(Salary) FROM Employee e2 WHERE e2.DepartmentId = d.Id);