FactEngine Query Language (FEQL) has a GROUP BY clause analogous to the GROUP BY clause in SQL and Cypher query languages.

GROUP BY clauses may be used in conjunction with a RETURN clause which is analogous to SELECT and RETURN clauses in the SQL and Cypher query languages.

For example, the following FEQL query has a RETURN, GROUP BY and ORDER BY clause, for a query that returns the count of orders taken by employees in December 2017 in descending order, over a database that stores orders for products (the Northwind database by Microsoft):

Syntax - GROUP BY Clause

<GROUPBYCLAUSE> ::= <KEYWDGROUPBY> <GROUPBYRETURNCOLUMN> (<COMMA> <GROUPBYRETURNCOLUMN>)*

<GROUPBYRETURNCOLUMN> ::= <MODELELEMENTNAME> <MODELELEMENTSUFFIX>? <PERIOD> <COLUMNNAMESTR>

<COMMA> ::= ,

<KEYWDGROUPBY> ::= GROUP BY

<MODELELEMENTNAME> ::= @"(([A-Z0-9]+[_a-z\-0-9]+[ |_]*)+[_|\s]?)+"

<MODELELEMENTSUFFIX> ::= @"([0-9])+"

<PERIOD> ::= .

<COLUMNNAMESTR> ::= @"(([a-zA-Z0-9][_a-z0-9]+)+[_|\s]?)+"; 

See Also: RETURN Clause