/SQL/Get max salary from each department 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 vote203 views1 answer
Many rows to 1 string mysql
SQL
0 vote176 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
1 vote256 views1 answer
Oracle create program if not exists
SQL
1 vote157 views1 answer
Importance of comment in mysql
SQL
0 vote179 views1 answer
Psql show db
SQL
7 votes163 views2 answers
Show size database mysql
SQL
8 votes167 views1 answer
Oracle find text in functions
SQL
1 vote157 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote169 views1 answer
Find all tables where column name exists oracle
SQL
3 votes167 views4 answers
Show sql server database
SQL