You can use the GROUP BY clause along with the MAX() function to achieve this. The query would look like this:

SELECT DepartmentID, MAX(Salary) AS MaxSalary
FROM employee_salaries
GROUP BY DepartmentID; 

This would group the salaries by department and then find the maximum salary for each department. The result would show the DepartmentID and the corresponding maximum salary value for that department.
Data una tabella degli stipendi dei dipendenti con le colonne EmployeeID, Salary e DepartmentID, scrivere una query SQL per trovare lo stipendio massimo per ogni reparto.