Write a SQL Query to find Max salary from each department.

Given a Employee table with three columns
ID, Salary, DeptID
10, 1000, 2
20, 5000, 3
30, 3000, 2

Answer:

We can first use group by DeptID on Employee table and then get the Max salary from each Dept group.

SELECT DeptID, MAX(salary)
FROM Employee
GROUP BY DeptID

Leave a Reply

Your email address will not be published. Required fields are marked *