count_distinct

Counts distinct non-NULL input values exactly.

Syntax

count_distinct( <expr> )

Returns

Returns int.

Examples

VALUES ('a'), ('b'), ('a'), ('c')
AGGREGATE count_distinct($0);