Min max salary for each department

View All Scripts Login to Run Script

Script Name Min max salary for each department
Description Min max salary for each department., which min salary less than 5000
Area SQL General / SQL Query
Contributor case quote
Created Friday April 27, 2018

Statement 1

SELECT department_id, MIN(salary), MAX (salary)  
FROM hr.employees  
GROUP BY department_id  
HAVING MIN(salary) < 5000  
ORDER BY department_id


DEPARTMENT_ID MIN(SALARY) MAX(SALARY)
10 4400 4400
30 2500 11000
50 2100 8200
60 4200 9000

4 rows selected.

Additional Information