The query finds the highest salary for each department.

• Use the GROUP BY clause to group the employees by department.

• Use the MAX() function to find the highest salary for each department.

• Combine the MA...read more

SELECT Department, MAX(Salary) AS HighestSalary

FROM Employees

GROUP BY Department;