跳到主要内容

SUM

Aggregate function.

The SUM() function calculates the sum of a set of values.

caution

NULL values are not counted.

Syntax

SUM(expression)

Arguments

ArgumentsDescription
expressionAny expression

Return Type

A double if the input type is double, otherwise integer.

Examples

tip

numbers(N) – A table for test with the single number column (UInt64) that contains integers from 0 to N-1.

SELECT SUM(number) FROM numbers(3);
+-------------+
| sum(number) |
+-------------+
| 3 |
+-------------+

SELECT SUM(number) AS sum FROM numbers(3);
+------+
| sum |
+------+
| 3 |
+------+

SELECT SUM(number+2) AS sum FROM numbers(3);
+------+
| sum |
+------+
| 9 |
+------+