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.

Arguments & returns

26 overloads

`quantile_cont(x, pos)`

Aggregate

Overload link	`x`	`pos`	Returns
#01	`BIGINT`	`DOUBLE`	`BIGINT`
#02	`BIGINT`	`DOUBLE[]`	`BIGINT`
#03	`DATE`	`DOUBLE`	`DATE`
#04	`DATE`	`DOUBLE[]`	`DATE`
#05	`DECIMAL`	`DOUBLE`	`DECIMAL`
#06	`DECIMAL`	`DOUBLE[]`	`DECIMAL`
#07	`DOUBLE`	`DOUBLE`	`DOUBLE`
#08	`DOUBLE`	`DOUBLE[]`	`DOUBLE`
#09	`FLOAT`	`DOUBLE`	`FLOAT`
#10	`FLOAT`	`DOUBLE[]`	`FLOAT`
#11	`HUGEINT`	`DOUBLE`	`HUGEINT`
#12	`HUGEINT`	`DOUBLE[]`	`HUGEINT`
#13	`INTEGER`	`DOUBLE`	`INTEGER`
#14	`INTEGER`	`DOUBLE[]`	`INTEGER`
#15	`SMALLINT`	`DOUBLE`	`SMALLINT`
#16	`SMALLINT`	`DOUBLE[]`	`SMALLINT`
#17	`TIME WITH TIME ZONE`	`DOUBLE`	`TIME WITH TIME ZONE`
#18	`TIME WITH TIME ZONE`	`DOUBLE[]`	`TIME WITH TIME ZONE`
#19	`TIME`	`DOUBLE`	`TIME`
#20	`TIME`	`DOUBLE[]`	`TIME`
#21	`TIMESTAMP WITH TIME ZONE`	`DOUBLE`	`TIMESTAMP WITH TIME ZONE`
#22	`TIMESTAMP WITH TIME ZONE`	`DOUBLE[]`	`TIMESTAMP WITH TIME ZONE`
#23	`TIMESTAMP`	`DOUBLE`	`TIMESTAMP`
#24	`TIMESTAMP`	`DOUBLE[]`	`TIMESTAMP`
#25	`TINYINT`	`DOUBLE`	`TINYINT`
#26	`TINYINT`	`DOUBLE[]`	`TINYINT`

Example

SELECT quantile_cont(x, 0.5)
FROM (VALUES
  (10),
  (20),
  (NULL)
) AS sample("x");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

In other engines

BigQuery`percentile_cont()`

SELECT PERCENTILE_CONT(x, 0.5 RESPECT NULLS) OVER ()

In DuckDB

SELECT QUANTILE_CONT(x, 0.5) OVER ()

SQLGlot example ↗

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3