Count

Description

Counts the number of values in an aggregation of values.

Syntax

Count ( expression )

Count ( * )

Arguments

expression is any scalar expression of any data type.

Remarks

Count is an aggregation function which can only be used in an aggregating Select statement. Null values are ignored except in the special form Count (*).