/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 vote266 views4 answers
Mysql count table rows
SQL
0 vote288 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
2 votes254 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
-1 vote245 views3 answers
Update mongodb version ubuntu
SQL
0 vote278 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote253 views1 answer
Sql server remove enter from string
SQL
0 vote251 views1 answer
Sql select by content lenght
SQL
1 vote273 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote270 views2 answers
How to get the date from datetime in mysql
SQL
5 votes243 views4 answers
Describe table postgres
SQL