QUANTILE

    Syntax

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

    More info:

    Description

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

    Argument types:

    • valueDate | Datetime | Fractional number | Integer
    • quantFractional number | Integer

    Return type: Same type as (value)

    Data source support

    ClickHouse 19.13, PostgreSQL 9.4.