/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

19 votes199 views6 answers
Sql create table
SQL
5 votes214 views3 answers
Bash: mysql: command not found
SQL
0 vote206 views1 answer
Postgres foreign key multiple columns
SQL
3 votes228 views2 answers
Oracle drop sequence
SQL
0 vote212 views1 answer
Sqlite3 pragma foreign keys
SQL
18 votes215 views3 answers
Get the list of all tables in sql server
SQL
0 vote216 views1 answer
Oracle swap partition
SQL
5 votes245 views1 answer
Add column table sql default value
SQL
0 vote198 views1 answer
Composit key in sql
SQL
1 vote213 views1 answer
ORA-01950
SQL