/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

3 votes272 views1 answer
Ms sql skip take
SQL
0 vote306 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote275 views1 answer
Mysql find db contarint
SQL
0 vote349 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote292 views1 answer
Get who is hired in february in sql
SQL
2 votes281 views1 answer
Oracle kill job by sid
SQL
8 votes354 views3 answers
Find table for column name in sql
SQL
0 vote285 views4 answers
Mysql desactivar trigger
SQL
0 vote267 views1 answer
Oracle call a function in a insert statement
SQL
0 vote305 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL