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:
