14.11. The order by clause
The list returned by a query may be ordered by any property of a returned class or components:
from DomesticCat cat
order by cat.name asc, cat.weight desc, cat.birthdate
The optional asc
or desc
indicate ascending or descending order
respectively.