Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links

Get Max salary of Employee each Department

How Get Max salary of Employee By Each department  With Employee Name ,Employee _ID ,Employee_Department ??

By      07-Nov-2023    2

Solutions


Rizwan Saqib

Get Max salary of Employee each Department

 

SELECT emp.Employee_ID, emp.Department_ID, emp.EmployeeName, emp.salary, dpt.DepartmentName

FROM Employees AS emp

JOIN Departments AS dpt ON emp.Department_ID = dpt.Department_ID

JOIN(SELECT   Department_ID  , MAX(salary) AS maxsalary FROM  Employees GROUP BY Department_ID) AS empMax

ON emp.Department_ID = empMax.Department_ID AND emp.salary = empMax.maxsalary Order by Salary desc

Your Answer

10060
Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links