On this page

    Categories: Aggregate, Window

    SUM

    Returns the sum of non-NULL input expressions.

    Syntax

    SUM(numeric_expression int64) → int64

    • numeric_expression: Numeric input expression.

    Examples

    SELECT SUM(column_name)
    -- Sum of the values in the specified column.
    

    SUM(numeric_expression float) → double

    • numeric_expression: Numeric input expression.

    Examples

    SELECT SUM(column_name)
    -- Sum of the values in the specified column.
    

    SUM(numeric_expression double) → double

    • numeric_expression: Numeric input expression.

    Examples

    SELECT SUM(column_name)
    -- Sum of the values in the specified column.
    

    SUM(numeric_expression decimal(0,0)) → double

    • numeric_expression: Numeric input expression.

    Examples

    SELECT SUM(column_name)
    -- Sum of the values in the specified column.
    

    SUM(numeric_expression int32) → int64

    • numeric_expression: Numeric input expression.

    Examples

    SELECT SUM(column_name)
    -- Sum of the values in the specified column.
    

    SUM(numeric_expression interval_day) → interval_day

    • numeric_expression: Numeric input expression.

    Examples

    SELECT SUM(column_name)
    -- Sum of the values in the specified column.
    

    SUM(numeric_expression interval_year) → interval_year

    • numeric_expression: Numeric input expression.

    Examples

    SELECT SUM(column_name)
    -- Sum of the values in the specified column.