/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

0 vote406 views1 answer
Move table to a different schema
SQL
1 vote373 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote382 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote340 views1 answer
Delete insert record in sql server
SQL
0 vote349 views1 answer
Oracle procedure teamplate
SQL
16 votes380 views6 answers
Python sqlite
SQL
0 vote366 views2 answers
Advantages of stored procedures sql
SQL
0 vote349 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
15 votes427 views3 answers
Mysql update add to existing value
SQL
0 vote372 views1 answer
Top frequency in sql server
SQL