/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 vote340 views1 answer
Mysql_union
SQL
0 vote353 views1 answer
Mysql grant grant option
SQL
3 votes348 views5 answers
Foreign keys
SQL
0 vote467 views1 answer
Postgresql powershell query
SQL
1 vote349 views1 answer
Apex ORA-20999
SQL
0 vote331 views1 answer
Sql change date format
SQL
3 votes325 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote346 views1 answer
Sql examples from framework
SQL
18 votes327 views3 answers
Mysql number format
SQL
1 vote331 views1 answer
How to find median of a column sql
SQL