/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

1 vote390 views1 answer
Sql select whole row max column
SQL
31 votes349 views3 answers
Sql count(*)
SQL
0 vote354 views1 answer
Mssql view column data type
SQL
3 votes366 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote409 views1 answer
Change date in pivot table to month in sql server
SQL
1 vote385 views1 answer
Sql current timestamp
SQL
2 votes388 views1 answer
Oracle trace file
SQL
0 vote355 views1 answer
Sqlite3 get data from table c
SQL
0 vote350 views1 answer
Add timestamp column to existing table ms sql server
SQL
14 votes380 views3 answers
Inner join sql oracle
SQL