Oracle›Aggregate Functions›MEDIAN
←LISTAGG

MEDIANAggregate Functions

STDDEV→

Returns the median value.

Syntax

MEDIAN(expr)

Example

Enter values below to update the example in real time.

salary→
median_salary→
employees→
SELECT MEDIAN(salary) AS median_salary FROM employees;