MEDIAN
Description
The MEDIAN function returns the median of the expression, equivalent to percentile(expr, 0.5).
Syntax
MEDIAN(<expr>)
Parameters
Parameter | Description |
---|---|
<expr> | The expression to calculate, supports types: Double, Float, LargeInt, BigInt, Int, SmallInt, TinyInt. |
Return Value
Returns the same data type as the input expression. Returns NULL if there is no valid data in the group.
Example
select datetime, median(scan_rows) from log_statis group by datetime;
select datetime, median(scan_rows) from log_statis group by datetime;
+---------------------+-------------------+
| datetime | median(scan_rows) |
+---------------------+-------------------+
| 2025-08-25 10:00:00 | 50 |
| 2025-08-25 11:00:00 | 30 |
+---------------------+-------------------+
select median(scan_rows) from log_statis group by datetime;
select median(scan_rows) from log_statis where scan_rows is null;
+-------------------+
| median(scan_rows) |
+-------------------+
| NULL |
+-------------------+