/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

1 vote288 views1 answer
Oracle sql create or replace view
SQL
0 vote307 views3 answers
Sql drop all tables
SQL
11 votes304 views3 answers
Change column name sql server management studio
SQL
0 vote303 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote395 views1 answer
Compare strings lexicographically in sql
SQL
1 vote283 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote314 views4 answers
What is unique key in sql
SQL
0 vote309 views1 answer
Sql composite key
SQL
0 vote291 views1 answer
Implizite joins sql
SQL
0 vote304 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL