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.