Aggregates Aggregate

quantile_cont()

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

Reference: DuckDB 2.0.0

Arguments & returns

28 overloads

quantile_cont(x, quantile)

Aggregate
Overload link xquantile Returns
#01 BIGINTDOUBLE BIGINT
#02 BIGINTDOUBLE[] BIGINT
#03 DATEDOUBLE DATE
#04 DATEDOUBLE[] DATE
#05 DECIMALDOUBLE DECIMAL
#06 DECIMALDOUBLE[] DECIMAL
#07 DOUBLEDOUBLE DOUBLE
#08 DOUBLEDOUBLE[] DOUBLE
#09 FLOATDOUBLE FLOAT
#10 FLOATDOUBLE[] FLOAT
#11 HUGEINTDOUBLE HUGEINT
#12 HUGEINTDOUBLE[] HUGEINT
#13 INTEGERDOUBLE INTEGER
#14 INTEGERDOUBLE[] INTEGER
#15 SMALLINTDOUBLE SMALLINT
#16 SMALLINTDOUBLE[] SMALLINT
#17 TIME WITH TIME ZONEDOUBLE TIME WITH TIME ZONE
#18 TIME WITH TIME ZONEDOUBLE[] TIME WITH TIME ZONE
#19 TIMEDOUBLE TIME
#20 TIMEDOUBLE[] TIME
#21 TIMESTAMP WITH TIME ZONEDOUBLE TIMESTAMP WITH TIME ZONE
#22 TIMESTAMP WITH TIME ZONEDOUBLE[] TIMESTAMP WITH TIME ZONE
#23 TIMESTAMPDOUBLE TIMESTAMP
#24 TIMESTAMPDOUBLE[] TIMESTAMP
#25 TIMESTAMPTZ_NSDOUBLE TIMESTAMPTZ_NS
#26 TIMESTAMPTZ_NSDOUBLE[] TIMESTAMPTZ_NS
#27 TINYINTDOUBLE TINYINT
#28 TINYINTDOUBLE[] TINYINT

Example

quantile_cont example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example with sample data ยท Run to view results.

In other engines

BigQuerypercentile_cont()

SELECT PERCENTILE_CONT(x, 0.5 RESPECT NULLS) OVER ()
In DuckDB
SELECT QUANTILE_CONT(x, 0.5) OVER ()

SQLGlot example โ†—