/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

14 votes379 views6 answers
Finding duplicate rows mysql
SQL
2 votes371 views1 answer
Postgresql group by month and year
SQL
0 vote326 views1 answer
How to export only procedures mysql
SQL
1 vote350 views1 answer
Postgresql substring last
SQL
2 votes311 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote1.1K views1 answer
Mysql custom sort order
SQL
0 vote376 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote334 views2 answers
Sqlalchemy core in clause
SQL
0 vote317 views1 answer
Test connection to sql server
SQL
0 vote366 views1 answer
How to check rollback status in oracle
SQL