/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 vote232 views1 answer
Sql developer sql worksheet not showing
SQL
2 votes220 views1 answer
How to find constraints on a table in oracle
SQL
3 votes233 views1 answer
Oracle sql commit example
SQL
0 vote209 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote216 views1 answer
Sql server current time without date
SQL
16 votes229 views2 answers
Add column if not exists mysql
SQL
0 vote223 views1 answer
Get number of rows in every table mysql
SQL
0 vote232 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
7 votes227 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
-1 vote203 views1 answer
How to format tables in sqlplus
SQL