/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 vote165 views1 answer
Sqlite3 not commit
SQL
0 vote210 views1 answer
Mysql collation portugues brasil
SQL
3 votes143 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote172 views1 answer
Sort by
SQL
0 vote149 views1 answer
Oracle exchange partition
SQL
1 vote158 views1 answer
How to truncate a table in databse
SQL
0 vote147 views1 answer
Sql counter column
SQL
0 vote155 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote140 views1 answer
Call rest api from postgresql
SQL
2 votes108 views1 answer
Oracle current date without time
SQL