CountDistinct

Returns the number of distinct values in each group. Values are compared without regard to case unless caseSensitive is true.

Numeric CountDistinct(AggregationArray valuesArray, Boolean caseSensitive = false)

Counts the distinct English words, with and without regard to case.

SELECT CountDistinct(English) as Words, CountDistinct(English, true) as CaseSensitiveWords FROM WordList:FlatTranslate

• Group By
• Aggregate Functions