/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 vote154 views1 answer
Select value from previous row in postgresql
SQL
0 vote152 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote169 views1 answer
Sql server remove 0 from left
SQL
0 vote208 views1 answer
How to find top 3 salary in sql
SQL
0 vote175 views1 answer
Geopoint from json mysql function
SQL
0 vote178 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote158 views1 answer
Max length found in mysql
SQL
3 votes170 views1 answer
Make a field auto_increment mysql
SQL
6 votes169 views2 answers
Mysql execute file
SQL
0 vote172 views1 answer
Reona
SQL