How find Max salary of Each Department
- MS Sql Server
- 813
- 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;
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
you can view the more detail via link https://www.youtube.com/watch?v=HpZgwHU1GcIChing xang
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Danial Comb
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!