Sum
Summary
The Sum function returns the sum of all input values and expressions.
Syntax
Sum(<any numeric data type or string that can convert to a numeric>) |
Return Type
The following table describes the possible return types:
|
Input Type
|
Return Type
|
|---|---|
| Byte, Short, Integer, or Long | Long |
| Decimal | Decimal |
| Float or Double | Double |
| String (numeric values stored as strings) | Double |
Examples
select Sum(amount) from xactly.xc_payment;1086123.01 |