/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

10 votes377 views1 answer
Oracle view dependencies
SQL
8 votes362 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
12 votes333 views1 answer
How to change the value of a table in sql
SQL
0 vote403 views1 answer
Tsql cte in a transaction
SQL
4 votes349 views1 answer
Add constraint fk
SQL
0 vote351 views1 answer
Ajax error exception handeling
SQL
0 vote353 views1 answer
VSCode SQL Server Connection error
SQL
0 vote345 views1 answer
How to close external sql connection in laravel
SQL
0 vote281 views1 answer
<script>alert
SQL
0 vote346 views1 answer
What is ssrs and ssis in sql server
SQL