Aggregate functions are used to calculate the aggregate values of the intervals belonging to a given data set domain property.
A single_valued_association_field
is designated by the name of an association-field in a one-to-one or many-to-one relationship. The type of a single_valued_association_field
and thus a single_valued_association_path_expression
is the abstract schema type of the related entity.
The argument to an aggregate function may be preceded by the keyword DISTINCT to specify that duplicate values are to be eliminated before the aggregate function is applied. Null values are eliminated before the aggregate function is applied, regardless of whether the keyword DISTINCT is specified.
aggregate_expression ::= { AVG | MAX | MIN | SUM } ([DISTINCT] state_field_path_expression) | COUNT ([DISTINCT] identification_variable | state_field_path_expression | single_valued_object_path_expression)
@see AvgFunction @see CountFunction @see MaxFunction @see MinFunction @see SumFunction @version 2.4 @since 2.3 @author Pascal Filion
|
|