/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 vote393 views1 answer
Check if mysql db is used
SQL
2 votes377 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
28 votes413 views6 answers
Sql update
SQL
25 votes354 views6 answers
Change column name mysql
SQL
0 vote334 views1 answer
Sql query with date
SQL
2 votes295 views1 answer
Sql group by different columns
SQL
11 votes363 views2 answers
Insert current date sql
SQL
0 vote381 views1 answer
Sql query use select name inside where clause
SQL
0 vote353 views1 answer
Dump multiple tables mysql
SQL
1 vote332 views1 answer
GROUP BY clause; this is incompati
SQL