mvSQL Database Function - AVERAGE()¶

Summary¶

Returns the average of the values in a group. Null values are ignored.

Syntax¶

AVERAGE(<column>)

Parameters¶

column¶

A reference to a column.

Returns¶

The average of the column values. For Vinyl version 3.3.33893 and higher, this function will always return a decimal, even if the column being averaged represents a whole number.

Examples¶

AVERAGE(Cost)

Returns

502.5