/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

4 votes301 views1 answer
Sql group by year
SQL
3 votes310 views1 answer
Sql set null
SQL
0 vote300 views1 answer
Postgres where
SQL
0 vote411 views1 answer
Php insert null mysql
SQL
0 vote302 views1 answer
Sql anywhere create procedure
SQL
0 vote322 views1 answer
Apex for oracle 11g
SQL
0 vote318 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
13 votes288 views2 answers
Display users in mysql
SQL
0 vote322 views1 answer
Postgres regex word boundary
SQL
14 votes344 views4 answers
Sql compiler
SQL