median
Description
The MEDIAN function returns the median of the expression.
Syntax
MEDIAN(<expr>)
Parameters
| Parameters | Description |
|---|---|
<expr> | The expression needs to be obtained |
Return Value
Returns the same data type as the input expression.
Example
select median(scan_rows) from log_statis group by datetime;
+---------------------+
| median(`scan_rows`) |
+---------------------+
| 50 |
+---------------------+
