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.