This topic describes the aggregate functions that are supported for SQL queries.

Function Description
COUNT() Returns the number of rows that match the specified condition.
COUNT(DISTINCT) Returns the number of rows with different values in the specified column.
SUM() Returns the sum of numeric columns.
AVG() Returns the average value of numeric columns.
MAX() Returns the maximum value in a column.
MIN() Returns the minimum value in a column.