Returns the average of a column in the resultset/group.

For example, with the following sample data set:

SELECT AVG(Field1) returns 15.

Returns the number of records in the resultset/group. When used with the optional DISTINCT keyword, COUNT returns the unique number of records in the resultset/group.

This parameter can be either an asterisk (*) or an expression. If an asterisk is used then all rows of the resultset/group are counted regardless of NULL status. If the expression for a row evaluated to NULL, it will not be counted.

For example, with the following sample data set:

SELECT COUNT(Field2) returns 3.

SELECT COUNT(Distinct Field2) returns 2.

Returns the largest value of the field in the resultset/group.

For example, with the following sample data set:

SELECT MAX(Field1) returns 23.

Returns the smallest value of the field in the resultset/group.

For example, with the following sample data set:

SELECT MIN(Field1) returns 5.

Returns the sum total of the field in the resultset/group.

For example, with the following sample data set:

SELECT SUM(Field1) returns 45.