Calculate values based on a value expression for every record
in a record stream. You do not specify a value expression for
the COUNT statistical function because it operates on the record
stream formed by the RSE, not on a value expression. When you
use the AVERAGE, MAX, MIN, and TOTAL statistical functions, you
specify a value expression and a record selection expression
(RSE). Oracle Rdb then:
o Evaluates the value expression for each record in the record
stream formed by the RSE
o Calculates a single value based on the results of the first
step
The RDML Statistical functions are:
o AVERAGE
o COUNT
o MIN
o MAX
o TOTAL
For more information and the syntax diagrams see the HELP entry
on each of these functions.
Additional Information:
explode
extract