Variance

Table of Contents



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

Numeric Variance(AggregationArray valuesArray)

round-pushpin Groups the synonyms by source word and computes Variance of the target word ids.
SELECT
    SourceWordId,
    Variance(TargetWordId) as Result
FROM
    WordList:Synonym
GROUP BY
    SourceWordId




SQL :: Sha256Agg
Returns a single SHA-256 hash of all of the values in each group, as a lower case hex string. Useful for detecting changes to a set of documents.
SQL :: Sha512Agg
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.
SQL :: ShowAggregateFunctions
Lists the built-in aggregate functions with their parameters and descriptions.
SQL :: Sum
Returns the total of the values in each group.
SQL :: Syntax
Basic KBSQL syntax and some examples.