ASA SQL Reference
  SQL Functions
    Function types

Aggregate functions

Aggregate functions summarize data over a group of rows from the database. The groups are formed using the GROUP BY clause of the SELECT statement. Aggregate functions are allowed only in the select list and in the HAVING and ORDER BY clauses of a SELECT statement.

List of functions 

The following aggregate functions are available:

• AVG function [Aggregate]

• COUNT function [Aggregate]

• GROUPING function [Aggregate]

• LIST function [Aggregate]

• MAX function [Aggregate]

• MIN function [Aggregate]

• STDDEV function [Aggregate]

• STDDEV_POP function [Aggregate]

• STDEV_SAMP function [Aggregate]

• SUM function [Aggregate]

• VAR_POP function [Aggregate]

• VAR_SAMP function [Aggregate]

• VARIANCE function [Aggregate]