How find Max salary of Each Department
By Rizwan Saqib   Posted on March-26-2018 679
MS Sql Server
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;
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;
By Rizwansaqib966   26-Mar-2018
Views 679
Share This with your friend by choosing any social account
You may also read following recent Post
![]() |
Types Of database
700 By Rizwan Saqib |
![]() |
History Of DataBase
716 By Rizwan Saqib |