CountDistinct

Table of Contents

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

Returns a single SHA-512 hash of all of the values in each group, as a lower case hex string. Useful for detecting changes to a set of documents.

Lists the built-in aggregate functions with their parameters and descriptions.

Returns the total of the values in each group.

Basic KBSQL syntax and some examples.

Returns the population variance of the values in each group: how far the values are spread from their mean.