On this page

    Categories: Aggregate, Window

    MIN

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

    Syntax

    MIN(expression time) → time

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

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

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression date) → date

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression int64) → int64

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression double) → double

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression boolean) → boolean

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression float) → float

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression interval_year) → interval_year

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression interval_day) → interval_day

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression varbinary) → varbinary

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression varchar) → varchar

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression int32) → int32

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.
    

    MIN(expression timestamp) → timestamp

    • expression: Input expression.

    Examples

    SELECT MIN(column_name)
    -- Min of the values in the specified column.