/SQL/How to get max from each department in sql

How to get max from each department in sql

SELECT firstname, MAX(salary)
FROM department d LEFT OUTER JOIN employee e
ON (d.department_id = e.department_id)
GROUP BY department_id;

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);

Similar codes

1 vote144 views1 answer
Foreign key in oracle sql developer
SQL
1 vote166 views1 answer
Add constraint sql
SQL
4 votes166 views1 answer
Mysql insert from local csv
SQL
0 vote167 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
1 vote186 views1 answer
Dropping a constraint in ms sql
SQL
5 votes163 views1 answer
How to check port number for postgresql
SQL
0 vote175 views2 answers
Functions with parameters SQL
SQL
5 votes170 views2 answers
Mysql date greater than 30 days
SQL
0 vote174 views1 answer
Mysql grant grant option
SQL
1 vote163 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL