QUANTILE

SyntaxSyntax

QUANTILE( value, quant )

QUANTILE( value, quant          [ FIXED ... | INCLUDE ... | EXCLUDE ... ]          [ BEFORE FILTER BY ... ]        )

DescriptionDescription

Returns the precise quant-level quantile (quant should be in range from 0 to 1).

Argument types:

• value — Date | Datetime | Fractional number | Integer
• quant — Fractional number | Integer

Return type: Same type as (value)

Data source supportData source support

ClickHouse 21.8, Oracle Database 12c (12.1), PostgreSQL 9.4, YDB.