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
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
round-pushpin 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


Related