SUM

All functions > AGGREGATE > SUM

Returns the sum of the values in the group.

Syntax

SUM(expr: T) → T
sql

Type Parameters:

  • T: Any numeric type (TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL)

Arguments

ParameterTypeRequiredDescription
exprTYesThe numeric expression to sum

Returns

The sum of all non-NULL values

Notes

  • Adds all numeric values in the group
  • NULL values are excluded from the calculation
  • Returns NULL if all values are NULL or group is empty
  • Result type matches input type
  • Can overflow for large sums depending on the database engine
  • Can be used with WHERE clause to filter before aggregation
  • Can be used with GROUP BY clause for grouped aggregation
Suggest changes to this page
Last update at: 2025/10/13 10:23:46