Aggregates Aggregate

quantile()

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.

Arguments & returns

3 overloads

Aggregate

Overload link	`x`	Returns
#01	`ANY`	`ANY`

Aggregate

Overload link	`x`	`pos`	Returns
#02	`ANY`	`DOUBLE`	`ANY`
#03	`ANY`	`DOUBLE[]`	`ANY`

SELECT quantile_disc(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.

PERCENTILE(x, 0.5)

In DuckDB

QUANTILE(x, 0.5)