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