Group By
Overview
Group by allows you to select a result set and group it (or collapse the results) by a given set of fields. Remaining non-grouped fields are availale only to Aggregate Functions.
Examples
SELECT
SourceWordId,
Min(TargetWordId) as Min,
Max(TargetWordId) as Max,
Sum(TargetWordId) as Sum,
Avg(TargetWordId) as Avg,
Count(TargetWordId) as Count
FROM
WordList:Synonym
GROUP BY
SourceWordId
Related
- Aggregate Functions - Aggregate functions are used to evaluate multiple rows when collapsing a group of documents.
- Avg - Computes the average value of a numeric field within a specified schema.
- Count - Tallies the occurrences of a specific field within a given schema.
- Max - Computes the maximum value of a numeric field within a specified schema.
- Min - Computes the minimum value of a numeric field within a specified schema
- Sum - Computes the total or summation value of a numeric field within a specified schema
- Keywords - A breakdown of all high-level statements available via the query handler.