How find Max salary of Each Department

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;