Examples | ARRAY_SUM Function | Teradata Vantage - Example: Querying a 1-D ARRAY Data Type and Table using ARRAY_SUM - Teradata Vantage - Analytics Database

SQL Data Types and Literals

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Publication Date
June 2022
Content Type
Data Types
SQL Reference
Publication ID
B035-1143-172K
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
uds1628112204571.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
ft:sourceId
dita
dita:id
exs1472253032394
lifecycle
latest
Product Category
Teradata Vantageā„¢

Consider the following 1-D ARRAY data type and table.

CREATE TYPE item_price AS DECIMAL(7,2) ARRAY[20];
CREATE TABLE inventory (itemkind INTEGER,
                        regular_price item_price,
                        sale_price item_price);

When evaluating the following query, each element value of the regular_price array is added together. The resulting value is divided by 2.

SELECT ARRAY_SUM(regular_price) / 2 FROM inventory;

The following is the same query using method-style syntax.

SELECT regular_price.ARRAY_SUM() / 2 FROM inventory;

In the following query, ARRAY_SUM adds each element within the specified scope of the regular_price array. The query returns a value representing the total sum of adding the affected element values of the regular_price array.

SELECT ARRAY_SUM(regular_price, NEW arrayVec(5,10))FROM inventory;

The following shows an alternate way to specify the same query.

SELECT ARRAY_SUM(regular_price, 5, 10) FROM inventory;