/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

7 votes314 views1 answer
Oracle pagination query offset
SQL
0 vote282 views1 answer
Parsing float to int in mysql
SQL
8 votes296 views1 answer
Unique vs primary key
SQL
1 vote302 views4 answers
Mysqldump 1 table only
SQL
0 vote329 views1 answer
Show specific events on mysql
SQL
1 vote301 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote294 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote358 views2 answers
Sql query print strings and int
SQL
1 vote319 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
25 votes303 views1 answer
Mysql grant all privileges to a user
SQL