Previous Topic

Next Topic

COUNT - SQL Function

COUNT {Expression}

The COUNT function returns the number of rows that satisfy a query’s search condition.

Count function syntax has these named arguments:

Parameter

Description

Expression

Required. The field reference or expression to count, or * to count all records.

For example:

  SELECT COUNT(*) FROM INHEAD WHERE (INHEAD.GrossAmount > 10000)

See Also

SQL Aggregate Functions

Book Contents

Book Index