ARRAY_SUM_GLOBAL
Returns the sum of elements in the array column accumulated over the rows in each group.
Syntax
ARRAY_SUM_GLOBAL(<array>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<array> | The array column whose elements will be summed. | Any ARRAY type |
Return Type
INTEGER
Example
The example below uses the following table Scores:
| nickname | recent_scores |
|---|---|
| steven70 | [1,3,4] |
| sanderserin | [3,5,6,7] |
| esimpson | [30,50,60] |
In this example, the function calculates the sum of each player’s recent scores. For example, the user esimpson received a sum of 140 points, so this value is returned in the score_sum column.
SELECT
nickname,
ARRAY_SUM_GLOBAL(recent_scores) AS score_sum
FROM
Scores
GROUP BY
nickname;
Returns:
| nickname | score_sum |
|---|---|
| steven70 | 8 |
| sanderserin | 21 |
| esimpson | 140 |