JPQL queries may optionally contain an order by
clause which specifies one or more fields to order by when returning
query results. You may follow the order by field
clause with the asc or desc
keywords, which indicate that ordering should be ascending or
descending, respectively. If the direction is omitted, ordering is
ascending by default.
select x from Magazine x order by x.title asc, x.price desc
The query above returns Magazine instances
sorted by their title in ascending order. In cases where the
titles of two or more magazines are the same, those instances will be
sorted by price in descending order.