14.11. The order by clause

The list returned by a query can 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.