Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

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.

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]