Statistical

Median

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


Top Next