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)

round-pushpin Counts the distinct English words, with and without regard to case.
SELECT CountDistinct(English) as Words, CountDistinct(English, true) as CaseSensitiveWords FROM WordList:FlatTranslate




Home
The home page
SQL :: Aggregate Functions
Aggregate functions compute one value from a group of rows.
SQL :: Avg
Returns the average (arithmetic mean) of the values in each group.
SQL :: Count
Returns the number of values in each group. Count(0) and Count(*) count the documents in each group.
SQL :: Distinct
Removes duplicate rows from the results of a SELECT.
SQL :: Expressions
Literals, operators, comments and variables in KBSQL.
SQL :: GeometricMean
Returns the geometric mean of the values in each group: the nth root of their product. Useful for growth rates and ratios.
SQL :: Group By
Group by collapses a result set into one row per distinct set of values.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: Max
Returns the largest numeric value in each group. Use MaxString for text.