Aggregate functions

An aggregate function returns one value, such as SUM or AVG, for a set of queried rows. You can extend the built-in aggregates to provide for your opaque data types. You can also create new, special-purpose aggregate functions.

For information about how to extend the built-in aggregates, refer to Extend existing aggregates. For information about how to create new aggregate functions, refer to Create user-defined aggregates. For information about how to use aggregate functions, see the Expression segment in the HCL OneDB™ Guide to SQL: Syntax.