Median – Oracle SQL Function

MEDIAN returns the median value of the expression argument.

Syntax:

MEDIAN(expression)

Example:

SELECT MEDIAN(max_salary) as med FROM JOBS;

MED
—————-
10000