Returns the average of all the element values in array_expr or the average of the elements within the specified scope.
Syntax
System Function
ARRAY_AVG ( array_expr [ scope_reference ] )
Method-Style
array_expr.ARRAY_AVG ( [ scope_reference ] )
- array_expr
-
An ARRAY expression, which is one of the following:
- A reference to an ARRAY column
- An ARRAY constructor expression
- A UDF expression
- A UDM expression
The element type of the array must be a numeric data type.
- scope_reference
- An ARRAY scope reference.