SQL Server Find the highest salaries for each department in it for each job

SQL Server Find the highest salaries for each department in it for each job

Please find below SQL server Query to find the highest salaries for each department in it for each job.

SELECT Deptno, Job, max(sal) as 'Max Salary' FROM Emp Group By Deptno, Job

Results: