MEDIAN

    Syntax

    MEDIAN( value )
    
    MEDIAN( value
            [ FIXED ... | INCLUDE ... | EXCLUDE ... ]
            [ BEFORE FILTER BY ... ]
          )
    

    More info:

    Description

    Returns the median value.

    Argument types:

    • valueDate | Datetime | Fractional number | Integer

    Return type: Same type as (value)

    Example

    MEDIAN([Profit])
    

    Data source support

    ClickHouse 19.13, PostgreSQL 9.4.