Aggregate Functions

Overview

Aggregate functions perform calculations based on a set of values and return a single value. Most aggregate functions ignore null values. Aggregate functions are often used with the GROUP BY clause of the SELECT statement.

Available Aggregate Functions

The following list shows the available aggregate functions:

AVG CORR COUNT COVAR_POP COVAR_SAMP MAX MIN MODE

PERCENTILE_CONT PERCENTILE_DISC STDDEV_POP STDDEV_SAMP SUM VAR_POP VAR_SAMP