/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

2 votes341 views3 answers
Sql truncate table
SQL
0 vote319 views1 answer
Sql server datetime to string
SQL
0 vote324 views1 answer
Create new schema mysql
SQL
15 votes304 views2 answers
How to drop database name in postgresql
SQL
0 vote367 views1 answer
Drop view in mysql
SQL
0 vote314 views4 answers
How to drop all tables in sql
SQL
1 vote328 views1 answer
Vagrant mysql downgrade version
SQL
0 vote331 views1 answer
Sql mod even odd
SQL
0 vote330 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote324 views1 answer
Less than and between in sql query
SQL