Count() mvSQL database function in Jitterbit App Builder¶
Summary¶
Returns the number of items in a group.
Syntax¶
COUNT(<column>)
COUNT(DISTINCT <column>)
Parameters¶
column¶
A column. Null values are not counted. With the optional DISTINCT
modifier, only unique values are counted.
Returns¶
The number of items in a group.
Examples¶
COUNT(CustomerId)
Returns
35