CSUM ( value_expression, sort_spec [,...] )
Syntax Elements
-
sort_spec
-
sort_expression [ ASC | DESC ]
-
value_expression
- A numeric literal or column expression for which a running sum is to be computed.
- By default, CSUM uses the default data type of value_expression. Larger numeric values are supported by casting it to a higher data type.
- The expression cannot contain any ordered analytical or aggregate functions.
-
sort_expression
- A literal or column expression or comma-separated list of literal or column expressions to be used to sort the values.
- The expression cannot contain any ordered analytical or aggregate functions.
- ASC
- Ascending sort order.
- DESC
- Descending sort order.