/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

3 votes220 views1 answer
Laravel paginate raw sql
SQL
0 vote208 views2 answers
Timing sql queries
SQL
0 vote226 views1 answer
Flask sqlalchemy session delete
SQL
0 vote187 views1 answer
Mysql sql select one day before
SQL
0 vote310 views1 answer
How to delete duplicate rows in oracle
SQL
2 votes253 views1 answer
Sqlite3 show columns name
SQL
0 vote194 views1 answer
Select last 2 characters sql
SQL
0 vote198 views1 answer
Psotgres multiple values
SQL
0 vote201 views1 answer
Drop all triggers oracle
SQL
0 vote248 views5 answers
Select concat alter table mysql
SQL