3.3. Aggregate Functions

Aggregate functions calculate a single value based ona set of values (this set may be zero values).

3.3.1. AVG() – Average

avg(<number>)

3.3.2. COUNT() – Count records

count(*)
count(<any>)

When the argument is * it will count all records without needing to provide any value.

3.3.3. MAX() – Maximum value

max(<number>)

3.3.4. MIN() – Minimum value

min(<number>)

3.3.5. SUM() – Total

sum(<number>)