Get Max salary of Employee each Department Ask Question
Solutions
Rizwan Saqib
Get Max salary of Employee each Department
SELECT emp.Employee_ID, emp.Department_ID, emp.EmployeeName, emp.salary, dpt.DepartmentName
FROM Employees AS emp
JOIN Departments AS dpt ON emp.Department_ID = dpt.Department_ID
JOIN(SELECT Department_ID , MAX(salary) AS maxsalary FROM Employees GROUP BY Department_ID) AS empMax
ON emp.Department_ID = empMax.Department_ID AND emp.salary = empMax.maxsalary Order by Salary desc
