ARRAY_SUM

Returns the sum of elements of <array>.

Syntax

ARRAY_SUM(<array>)

Parameters

Parameter Description Supported input types
<array> The array to be used to calculate the function. Any array of numeric types

Return Type

The return type depends on the input type:

Array element type Return type
INTEGER BIGINT
BIGINT NUMERIC(38, 0)
NUMERIC(precision, scale) NUMERIC(precision, scale)
REAL REAL
DOUBLE DOUBLE

Example

SELECT
	ARRAY_SUM([ 4, 1, 3, 2 ]) AS levels;

Returns: 10