Aggregate Functions

<< Click to Display Table of Contents >>

Navigation:  Apollo SQL > Aggregate Functions >

Aggregate Functions

Apollo SQL supports the following aggregate functions:

 

AVG

Returns the average of the values in a specified column or an expression.

COUNT

Counts the number of rows retrieved by a SELECT statement.

MAX

Calculates the largest value for a numeric column.

MIN

Calculate the smallest value for a numeric column.

STDEV

Computes the standard deviation.

SUM

Returns the sum of all values in a column.

 

See Also

Arithmetic Functions, Conditional Functions, String Functions