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. |