Skip to main content

median

The median* functions are the aliases for the corresponding quantile* functions. They calculate median of a numeric data sample.

Functions:

Example

Input table:

┌─val─┐
│ 1 │
│ 1 │
│ 2 │
│ 3 │
└─────┘

Query:

SELECT medianDeterministic(val, 1) FROM t;

Result:

┌─medianDeterministic(val, 1)─┐
│ 1.5 │
└─────────────────────────────┘