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

How to get max salary in each department in sql

How to find max and min salary in sql

SELECT MAX(SALARY) FROM EMPLOYEES
UNION
SELECT MIN(SALARY) FROM EMPLOYEES;

Second max salary in sql

SELECT MAX(SALARY) 'SECOND_MAX' FROM EMPLOYEES
WHERE SALARY <> (SELECT MAX(SALARY) FROM EMPLOYEES);

How to get max salary in 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;

-1

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

-1

Similar codes

0 vote210 views1 answer
Postgres sql alter table delete row
SQL
0 vote227 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote201 views1 answer
Oracle sql date summer time
SQL
0 vote219 views1 answer
Import big data to mysql
SQL
0 vote234 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote243 views1 answer
T-sql update table variale
SQL
0 vote216 views1 answer
Mysql count with two joins
SQL
0 vote228 views1 answer
Change permission to database mysql
SQL
8 votes206 views1 answer
Oracle add month
SQL
1 vote215 views1 answer
Postgres convert exisiting column to text
SQL