/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 vote140 views1 answer
Find most frequent value in SQL column
SQL
0 vote214 views1 answer
Sql if clause within where clause
SQL
0 vote135 views1 answer
Mysqldump ignore table
SQL
19 votes137 views4 answers
Rename database in sql
SQL
7 votes145 views2 answers
How to create index mysql
SQL
0 vote155 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote140 views1 answer
We are intrested to work with your organization
SQL
1 vote135 views1 answer
Get rows affected mysql python
SQL
0 vote175 views1 answer
Postgres foreign key multiple columns
SQL
6 votes176 views3 answers
Mysql change auto_increment start value
SQL