Median

Table of Contents

Returns the median (middle) value in each group. For an even number of values it is the average of the two middle values.

Numeric Median(AggregationArray valuesArray)

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

SELECT
    SourceWordId,
    Median(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.