MSUM Function Syntax | Teradata Vantage - 17.10 - MSUM Function Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)
MSUM ( value_expression, width, sort_spec [,...] )

Syntax Elements

value_expression
The expression cannot contain any ordered analytical or aggregate functions.
width
The number of previous rows to be used in the computation.
The value is always a positive integer literal.
The maximum is 4096.
sort_spec
sort_expression [ ASC | DESC ]
sort_expression
A literal or column expression or comma-separated list of literal or column expressions to be used to sort the values.
ASC
Ascending sort order.
DESC
Descending sort order.