Skip to Content

Turn your connections into holiday cash with our new Customer Referral Program! Learn more

✕

This documentation is for version 4 of App Builder, the new name for Vinyl. Access the Vinyl documentation here.

✕

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