/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 vote244 views1 answer
How much space does sql server take per row
SQL
16 votes258 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote237 views1 answer
Mysql query with sql to get the next row
SQL
0 vote224 views3 answers
Between keyword sql
SQL
0 vote237 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote226 views1 answer
Composit key in sql
SQL
0 vote249 views1 answer
Plpgsql raise notice
SQL
3 votes231 views2 answers
Create schema postgres
SQL
3 votes226 views1 answer
MySQL DELETE JOIN
SQL
0 vote240 views1 answer
Get relation data in mysql using query to excel
SQL