/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 vote188 views1 answer
How to add more columns to a table in mysql
SQL
1 vote188 views1 answer
Count mysql server db tables
SQL
0 vote197 views1 answer
Replace divide by zero error with 0 in sql
SQL
-1 vote177 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote178 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote177 views1 answer
How to set sql_mode for a query in CI model
SQL
11 votes200 views5 answers
Laravel db facade
SQL
0 vote243 views2 answers
Wordpress change url in database
SQL
1 vote178 views1 answer
Right outer vs left outer join
SQL
0 vote167 views1 answer
Deny select insert update delete sql
SQL