On this page

    Categories: Aggregate, Window

    MAX

    Returns the maximum value among the non-NULL input expressions.

    Syntax

    MAX(expression float) → float

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression boolean) → boolean

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression varchar) → varchar

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression decimal(0,0)) → double

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression double) → double

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression interval_day) → interval_day

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression int64) → int64

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression date) → date

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression int32) → int32

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression interval_year) → interval_year

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression varbinary) → varbinary

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression time) → time

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.
    

    MAX(expression timestamp) → timestamp

    • expression: Input expression.

    Examples

    SELECT MAX(column_name)
    -- Max of the values in the specified column.