/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

0 vote108 views1 answer
Postgressql uuid
SQL
8 votes101 views1 answer
How to remove tables from postgresql
SQL
0 vote267 views1 answer
Current month transactions in mysql
SQL
1 vote112 views1 answer
Mysql show database size in mb
SQL
1 vote119 views2 answers
Check if word is in column sql
SQL
0 vote119 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote106 views1 answer
How to fetch unique records from two tables
SQL
10 votes102 views5 answers
Mysql create user
SQL
1 vote109 views1 answer
Generate random data postgresql
SQL
2 votes108 views1 answer
Sql ignore accents
SQL