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]
• BIT_AND function [Aggregate]
• BIT_OR function [Aggregate]
• BIT_XOR function [Aggregate]
• COVAR_POP function [Aggregate]
• COVAR_SAMP function [Aggregate]
• COUNT function [Aggregate]
• CORR function [Aggregate]
• FIRST_VALUE function [Aggregate]
• GROUPING function [Aggregate]
• LAST_VALUE function [Aggregate]
• LIST function [Aggregate]
• MAX function [Aggregate]
• MIN function [Aggregate]
• REGR_AVGX function [Aggregate]
• REGR_AVGY function [Aggregate]
• REGR_COUNT function [Aggregate]
• REGR_INTERCEPT function [Aggregate]
• REGR_R2 function [Aggregate]
• REGR_SLOPE function [Aggregate]
• REGR_SXX function [Aggregate]
• REGR_SXY function [Aggregate]
• REGR_SYY function [Aggregate]
• SET_BITS function [Aggregate]
• STDDEV function [Aggregate]
• STDDEV_POP function [Aggregate]
• STDDEV_SAMP function [Aggregate]
• SUM function [Aggregate]
• VAR_POP function [Aggregate]
• VAR_SAMP function [Aggregate]
• VARIANCE function [Aggregate]
• XMLAGG function [Aggregate]