COUNTD_APPROX

SyntaxSyntax

COUNTD_APPROX( value )

COUNTD_APPROX( value
               [ FIXED ... | INCLUDE ... | EXCLUDE ... ]
               [ BEFORE FILTER BY ... ]
             )

DescriptionDescription

Returns the approximate number of unique values in the group. Faster than COUNTD, but doesn't guarantee accuracy.

Argument types:

• value — Any

Return type: Integer

ExampleExample

COUNTD_APPROX([ClienID])

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, Oracle Database 12c (12.1), Yandex Documents, YDB.