/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

1 vote142 views1 answer
Oracle get current schema
SQL
2 votes137 views1 answer
Get first n letter of department name in sql
SQL
3 votes148 views1 answer
Kill mysql processlist in whose time more than 200
SQL
2 votes159 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote135 views1 answer
Mysql function variable
SQL
0 vote134 views1 answer
Update top 100 sql
SQL
0 vote173 views1 answer
Convert rows into columns in oracle
SQL
0 vote130 views1 answer
Output table plsql
SQL
0 vote144 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
3 votes143 views2 answers
Monthname sql
SQL