Table 131. CSum (Cumulative Sum) Function
Field | Description |
|---|---|
Description | Accumulates a sum over an ordered set of rows, providing the current values of the SUM on each row |
Syntax: | CSum(value_expression, sort_expression_list) |
value_expression | A value_expression is a scalar numeric column expression for which a running sum is to be computed. |
sort_expression_list | The sort_expression_list is a list of expressions (with optional sort direction specifications) separated by commas. That is, it specifies the column references used to sort the values. The default sort direction is ascending (ASC). |