JoSQL User Manual - Order By Clause

Order By Clause

The general syntax for the ORDER BY clause is:

ORDER BY Expression | Integer [ ASC | DESC ] [ , Expression | Integer [ ASC | DESC ] ]*

The ORDER BY clause provides the ability to order the results of the Query. You can order by any expression or integers which refer to a "column" in the SELECT clause.

For example:

SELECT name,
       length,
       lastModified
FROM   java.io.File
ORDER BY upper (name), length DESC, 3 DESC