count_distinct_exact¶
Description¶
Count the exact number of distinct values in the input using complete enumeration (slower than count_distinct).
Return type¶
int64
Domain¶
This is an aggregate function (aggregates rows over a group in aggregate verbs.)
This is a window function (calculates over a group of multiple input rows using windowing.)
Categories¶
Usage¶
count_distinct_exact( item ... )
Argument |
Type |
Required |
Multiple |
---|---|---|---|
item |
any |
Required |
Can be multiple |
Aliases¶
countdistinctexact
(deprecated)