/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

1 vote330 views1 answer
Postgresql where datetrunc month and year equal
SQL
2 votes242 views2 answers
Mysql get last character of string
SQL
0 vote266 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote299 views1 answer
Get a list of tables and the primary key
SQL
0 vote335 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote301 views1 answer
Query string starts with vowels
SQL
11 votes267 views2 answers
Sql between date range
SQL
2 votes273 views3 answers
Application.properties spring boot mysql
SQL
13 votes296 views4 answers
Command line mysql import
SQL
0 vote324 views1 answer
Drop view in mysql
SQL