Mode

Table of Contents

Returns the value that occurs most often in each group. When several values are tied, the first one encountered is returned.

Numeric Mode(AggregationArray valuesArray)

Groups the synonyms by source word and computes Mode of the target word ids.

SELECT
    SourceWordId,
    Mode(TargetWordId) as Result
FROM
    WordList:Synonym
GROUP BY
    SourceWordId

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.