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