Aggregate Functions and nPath - Teradata® Database
Database Analytic Functions
- Product
- Teradata® Database
- Release Number
- 16.10
- 15.10
- Published
- November 2017
- Language
- English (United States)
- Last Update
- 2018-05-10
- dita:mapPath
- hoj1499019223447.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- B035-1206
- lifecycle
- previous
- Product Category
- Teradata® Database
- Some aggregate functions, such as FIRST, LAST, COUNT, and SUM, are computed over more than one symbol. In such cases, the symbols must be enclosed in parentheses, along with the ANY keyword. The symbols in an expression must belong to the same input stream.
- You can use the Teradata aggregate functions in the RESULTS clause, in addition to the nPath-specific Aggregate functions.