/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 vote231 views1 answer
Jenkins SQLCMD run
SQL
0 vote287 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
8 votes240 views2 answers
Between operator
SQL
0 vote236 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote221 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote227 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote192 views1 answer
Create duplicate table in postgresql
SQL
6 votes228 views2 answers
Mysql first day of month
SQL
0 vote246 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote237 views1 answer
Restore backup mysql .gz
SQL