/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 vote143 views1 answer
Call function in query sql server
SQL
0 vote175 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote149 views2 answers
Tsql row number
SQL
0 vote155 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote157 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
2 votes161 views2 answers
Install sqlalchemy
SQL
0 vote159 views1 answer
Tinydb add table
SQL
3 votes151 views2 answers
Monthname sql
SQL
2 votes140 views1 answer
Scaffold npgsql net core
SQL
1 vote143 views2 answers
String to date postgres
SQL