Description | The |
Syntax | AVG( |
Output | numeric |
Variables
number
: the numeric field to be averaged.
Example
AVG(Value
) OVER (Partition by Group
)
ID | Group | Value | AVG |
1 | A | 10 | 15 |
2 | A | 20 | 15 |
3 | A | 15 | 15 |
4 | B | 30 | 35 |
5 | B | 40 | 35 |
Calculates the average value of a specified numeric field across a range or partition
Description | The |
Syntax | AVG( |
Output | numeric |
number
: the numeric field to be averaged.
AVG(Value
) OVER (Partition by Group
)
ID | Group | Value | AVG |
1 | A | 10 | 15 |
2 | A | 20 | 15 |
3 | A | 15 | 15 |
4 | B | 30 | 35 |
5 | B | 40 | 35 |