Previous Topic

Next Topic

SQL Aggregate Functions

Function

Description

AVG

Averages all numeric values in a field.

COUNT

Counts the number of rows in a result set.

MAX

Determines the maximum value in a field.

MIN

Determines the minimum value in a field.

SUM

Totals all numeric values in a field.

In This Section

AVG - SQL Function

COUNT - SQL Function

MAX - SQL Function

MIN - SQL Function

SUM - SQL Function

See Also

SQL Functions

Book Contents

Book Index