10.7. Ordering
Prev | Chapter 10. JPA Query | Next

## 10.7. Ordering

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.

Prev | Up | Next
10.6. Query Parameters | Home | 10.8. Aggregates