/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 vote288 views1 answer
Check if table exists oracle
SQL
0 vote323 views2 answers
Mysql two column combination unique
SQL
0 vote332 views1 answer
C# sql transaction multiple connections
SQL
2 votes312 views2 answers
Convert_tz mysql
SQL
2 votes343 views1 answer
How to check if a row is null in sql
SQL
-1 vote288 views1 answer
Ssms connect with connection string
SQL
0 vote269 views1 answer
Suse start MySQL
SQL
0 vote286 views1 answer
Sql select by content lenght
SQL
1 vote297 views1 answer
ALL_TAB_PARTITIONS
SQL
1 vote292 views1 answer
Sql where last 12 months
SQL