ARRAY_SUM Function | Data Types and Literals | Teradata Vantage - 17.10 - ARRAY_SUM - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Returns a value representing the total sum of adding the values of each element in array_expr or the sum of the elements within the specified scope.

The result type of ARRAY_SUM is NUMBER unless the element type of the array argument is FLOAT. In this case, the result type is FLOAT.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.