/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

3 votes266 views1 answer
Mysql UPDate with enner join
SQL
5 votes310 views2 answers
Postgresql add not null constraint
SQL
2 votes281 views1 answer
Apex execute batch job
SQL
1 vote239 views1 answer
Postgres grant read only access to database
SQL
0 vote372 views1 answer
Mysql show schema
SQL
0 vote271 views1 answer
Implicit inner join table alias with id values
SQL
7 votes299 views2 answers
Postgres concat
SQL
0 vote290 views1 answer
Sql get month from date
SQL
0 vote279 views1 answer
Oracle job schedules
SQL
2 votes313 views1 answer
Where clause for child record apex
SQL