/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 vote278 views1 answer
Sql case sttement with set
SQL
1 vote264 views1 answer
Show table columns
SQL
2 votes269 views1 answer
Mysql find tables with name
SQL
0 vote277 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
31 votes276 views3 answers
SQL Server change column data type
SQL
0 vote253 views1 answer
Mysql select row with min date
SQL
0 vote274 views1 answer
Exec procedure oracle
SQL
12 votes257 views1 answer
How to change the value of a table in sql
SQL
0 vote284 views2 answers
Drop tables from local table database postgres
SQL
3 votes260 views1 answer
Make a field auto_increment mysql
SQL