Mean

Table of Contents



Returns the arithmetic mean of the values in each group (the same as Avg).

Numeric Mean(AggregationArray valuesArray)

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




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 :: CountDistinct
Returns the number of distinct values in each group. Values are compared without regard to case unless caseSensitive is true.
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.