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)