/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 vote360 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote353 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
1 vote344 views1 answer
Oracle extract minute from date
SQL
1 vote357 views1 answer
Mysql count all table rows
SQL
2 votes349 views1 answer
Sql server current date minus 5 years
SQL
1 vote380 views1 answer
Hangfire clear all jobs
SQL
0 vote314 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote345 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
2 votes344 views1 answer
How to delete columns in sql
SQL
7 votes368 views1 answer
Show line number in sql server
SQL