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

ORDER 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 - ORDER BY Clause

<ORDERBYCLAUSE> ::= <KEYWDORDERBY> <ORDERBYCOLUMN> (<COMMA> <ORDERBYCOLUMN>)*

<ORDERBYCOLUMN> ::= [<MODELELEMENTNAME> <MODELELEMENTSUFFIX>? <PERIOD> <COLUMNNAMESTR> | <KEYWDCOUNTSTAR>] [<KEYWDASC> | <KEYWDDESC>]?

<COMMA> ::= ,

<KEYWDCOUNTSTAR> ::= COUNT(*)

<KEYWDORDERBY> ::= ORDER 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