How find Max salary of Each Department
- MS Sql Server
- 940
- March-26-2018
- by Rizwan Saqib
SELECT Employee_ID
, Emp.Name
, Emp.department_id
, Emp.Salary
, D.DepartmentName
FROM (SELECT Employee_ID
, Name
, department_id
, Salary
, Max(salary) OVER (PARTITION BY Department_ID) dept_max_sal
FROM EMPLOYEE) AS Emp
Join Department D on d.Department_ID = Emp.Department_ID
WHERE salary = dept_max_sal;
