Default password has not been changed

The admin password is set to its default value, it is recommended that you change it immediately!

You can change this password by logging in, navigating to My -> Account -> Password.

Current admin login:
Username:"[email protected]"
Password:"2Tight2Wiki@"

Group By

Table of Contents

Overview

Examples

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

Selects and groups by the SourceWordId from the Synonym schema and performs various aggregations.

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

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.

<< First | < Previous | Next > | Last >>