Find median of the column values in oracle using MEDIAN mathematical function

This explains how to find the median of the values in oracle using mathematical function, MEDIAN.

There is a Mathematical function in oracle by the name, MEDIAN which is used to find the median of the column (or set of values) in oracle. Median is nothing but the middle number in the sequence of numbers.

Syntax: MEDIAN(expression)
Here expression is set of values or a column of the table.

Ex1: SELECT MEDIAN(sal) FROM emp;
This returns median of the sal column values from the emp table as result.