Please use the links in the table below to view the eXtremeSQL aggregate functions:
avg(column_name) Returns the average of all values in the specified column count(*) Returns the count of rows in the result set max(column_name) Returns the maximum value in the specified column min(column_name) Returns the minimum value in the specified column sum(column_name) Returns the sum of all values in the specified column string_agg(strings, sep) Returns the concatenation of string expression stringsdelimited by separatorsepuser-defined_functions The Sql Engine allows user-defined functions to perform custom aggregation, i.e. functions used with the SQL group byoperator.