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



You may also read following recent Post