Aggregates Aggregate

quantile_disc()

Returns the exact quantile number between 0 and 1 . If pos is a LIST of FLOATs, then the result is a LIST of the corresponding exact quantiles.

Reference: DuckDB 2.0.0

Arguments & returns

3 overloads

quantile_disc(x)

Aggregate
Overload link x Returns
#01 ANY ANY

quantile_disc(x, quantile)

Aggregate
Overload link xquantile Returns
#02 ANYDOUBLE ANY
#03 ANYDOUBLE[] ANY

Example

quantile_disc example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example with sample data · Run to view results.