Avg
Summary
The Avg function returns the arithmetic mean for all input values.
Syntax
Avg(<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, Long, Float, or Double | Double |
| Decimal | Decimal |
| String (numeric values stored as strings) | Double |
Examples
select Avg(amount) from xactly.xc_payment;5406.67 |