ARRAY_SUM
All functions > ARRAY > ARRAY_SUM
Returns the sum of all numeric elements in an array.
Signatures
Returns: The sum of all numeric elements in the array
ARRAY_SUM(array: ARRAY<T>) → Tsql
| Parameter | Type | Required | Description |
|---|---|---|---|
array | ARRAY<T> | Yes | The numeric array to sum |
Notes
- Adds all numeric values in the array
- Ignores NULL values (treats them as 0)
- Returns NULL for empty arrays
- Handles negative values correctly
- May overflow for very large sums
- Only works with numeric arrays
On this page