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

The home page

Aggregate functions compute one value from a group of rows.

Returns the average (arithmetic mean) of the values in each group.

Returns the number of values in each group. Count(0) and Count(*) count the documents in each group.

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

Removes duplicate rows from the results of a SELECT.

Literals, operators, comments and variables in KBSQL.

Returns the geometric mean of the values in each group: the nth root of their product. Useful for growth rates and ratios.

Group by collapses a result set into one row per distinct set of values.

A breakdown of all of the statements and keywords supported by the query processor.