/SQL/Select max salary from each department in sql

Select max salary from each department in sql

Get max salary from each department sql

--Find out the name of top earner in each departments
--Output has Name, Department name and max salary of the department

SELECT E.FIRST_NAME , D.DEPARTMENT_NAME, E.SALARY
FROM EMPLOYEES E
JOIN DEPARTMENTS D ON E.DEPARTMENT_ID = D.DEPARTMENT_ID
WHERE SALARY IN(SELECT MAX(E.SALARY)
FROM EMPLOYEES E
JOIN DEPARTMENTS D ON E.DEPARTMENT_ID = D.DEPARTMENT_ID
GROUP BY DEPARTMENT_NAME);

Source: grepper.com

Similar codes

0 vote320 views1 answer
View to table
SQL
1 vote327 views1 answer
Oracle user last connection date
SQL
0 vote339 views5 answers
Sql table intermédiaire
SQL
5 votes329 views2 answers
Oracle apex debug mode
SQL
0 vote322 views1 answer
Insert array into mysql column
SQL
1 vote335 views1 answer
Error code 1292 mysql workbench
SQL
5 votes327 views1 answer
Oracle create table comment
SQL
0 vote361 views1 answer
Hex string sql becomes int64
SQL
0 vote325 views1 answer
Mysql update set sum
SQL
0 vote270 views2 answers
Jupyter notebook connect to database
SQL