SELECT department_id, MEDIAN(salary) FROM employees GROUP BY department_id; DEPARTMENT_ID MEDIAN(SALARY) ------------- -------------- 10 4400 20 9500 30 2850 40 6500 50 3100