/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 vote328 views1 answer
Postgresql auto increment not working
SQL
1 vote352 views2 answers
Full join
SQL
0 vote332 views1 answer
Set Mamp mysql globally
SQL
2 votes308 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote306 views1 answer
Mysql set boolean default value
SQL
1 vote305 views1 answer
Base nosql
SQL
0 vote323 views1 answer
OFFSET consulta mysql
SQL
0 vote308 views1 answer
Sql datediff month
SQL
2 votes306 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote347 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL