Aggregate function. Calculate the sum of a set of numbers. NULL values are ignored. If no values can be summed, this function returns NULL.


SUM ( [DISTINCT] expression )


  • DISTINCT: optional keyword. If present, will sum the unique values.

  • expression: any expression. This may be a column name, the result of another function, or a math operation.

Return Type

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


CREATE TABLE sumptuous (id int primary key, number1 int, number2 int);

INSERT INTO sumptuous VALUES (1, 1024, 4096), (2, 23452, NULL);

SELECT SUM(number1), SUM(number2) FROM sumptuous;
| SUM(number1) | SUM(number2) |
|        24476 |         4096 |