Library /sys$common/syshlp/SQL$HELP72.HLB  —  Aggregate Functions, AVG Function
    The AVG function calculates the average of the values specified
    by the value expression in its argument. If there are no rows in
    the result table to which the AVG function is applied, it returns
    a null value.

    The AVG function must refer to a value with a numeric or INTERVAL
    data type. The value it returns is a floating-point data type for
    numeric expressions, or an INTERVAL data type.

    If a value is NULL, the row is treated as missing and, if your
    dialect is set to an ANSI/ISO SQL standard, a warning message is
    returned.
Close Help