/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 vote117 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
4 votes168 views1 answer
W3schools create table
SQL
0 vote149 views1 answer
Min and max salary and name in sql
SQL
0 vote177 views1 answer
Find duplicate users by email address in mysql
SQL
2 votes190 views6 answers
In operator in sql
SQL
1 vote180 views1 answer
T-sql disable system versioning
SQL
51 votes255 views6 answers
Change column name sql
SQL
0 vote159 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
2 votes156 views1 answer
How to check if a row is null in sql
SQL
1 vote149 views1 answer
Oracle start job
SQL