# quantilesDeterministic (/docs/reference/sql/aggregate-functions/quantilesdeterministic)



This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See [SQL interface scope](/docs/reference/clickhouse-compatibility#service-interfaces).

Computes multiple approximate [quantiles](https://en.wikipedia.org/wiki/Quantile) of a numeric data sequence at different levels simultaneously, using deterministic reservoir sampling.

This function is equivalent to [`quantileDeterministic`](/reference/functions/aggregate-functions/quantileDeterministic) but allows computing multiple quantile levels in a single pass, which is more efficient than calling individual quantile functions.

**Syntax**

```sql
quantilesDeterministic(level1, level2, ...)(expr, determinator)
```

**Parameters**

* `level` — Levels of quantiles. One or more constant floating-point numbers from 0 to 1. We recommend using `level` values in the range of `[0.01, 0.99]`. [`Float*`](/reference/data-types/float)

**Arguments**

* `expr` — Expression over the column values resulting in numeric data types, `Date` or `DateTime`. [`(U)Int*`](/reference/data-types/int-uint) or [`Int128`](/reference/data-types/int-uint) or [`UInt128`](/reference/data-types/int-uint) or [`Int256`](/reference/data-types/int-uint) or [`UInt256`](/reference/data-types/int-uint) or [`Float*`](/reference/data-types/float) or [`Date`](/reference/data-types/date) or [`DateTime`](/reference/data-types/datetime)
* `determinator` — Number whose hash is used instead of a random number generator in the reservoir sampling algorithm to make the result of sampling deterministic. [`UInt*`](/reference/data-types/int-uint)

**Returned value**

Array of approximate quantiles of the specified levels in the same order as the levels were specified. [`Array(Float64)`](/reference/data-types/array) or [`Array(Date)`](/reference/data-types/array) or [`Array(DateTime)`](/reference/data-types/array)

**Examples**

**Computing multiple deterministic quantiles**

```sql title=Query
SELECT quantilesDeterministic(0.25, 0.5, 0.75)(number, number) FROM numbers(10)
```

```text title=Response
┌─quantilesDeterministic(0.25, 0.5, 0.75)(number, number)─┐
│ [2.25,4.5,6.75]                                         │
└─────────────────────────────────────────────────────────┘
```

*Introduced in version 1.1.0.*
