COUNT(DISTINCT ...)

Counts the number of distinct non-null input values.

Syntax

COUNT(DISTINCT X)

Type: any

The values to be counted.

Type: bigint

Returns the number of distinct non-null input values.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!