7.9. The order by clause

The list returned by a query may be ordered by any property of a returned class or components:

select cat from DomesticCat cat
order by cat.name asc, cat.weight desc, cat.birthdate

The optional asc or desc indicate ascending or descending order respectively.