QUANTILE_APPROX
Syntax
Standard
Extended
QUANTILE_APPROX( value, quant )
QUANTILE_APPROX( value, quant
[ FIXED ... | INCLUDE ... | EXCLUDE ... ]
[ BEFORE FILTER BY ... ]
)
More info:
Description
Returns the approximate quant
-level quantile (quant
should be in range from 0 to 1).
Argument types:
value
—Date | Datetime | Fractional number | Integer
quant
—Fractional number | Integer
Return type: Same type as (value
)
Data source support
ClickHouse 21.8
, Files
, Google Sheets
, Yandex Documents
.