| Parameter | Type | Description |
|---|---|---|
value | decimal, double | The values to be averaged (`NULL` values are ignored) |
Returns: decimal
Example
query:
SELECT AVG(close_value)
FROM sales_pipelineresult:
| avg |
|---|
| 1,490.92 |
AVG
AVG returns the average of all the entries in a column which are not NULL and can only be used with numeric data.