Salesforce Platform Developer I Certification Guide

[ORDER BY fieldOrderByList {ASC|DESC} [NULLS {FIRST|LAST}] ]

This is a list of one or more fields, separated by commas, that are used to order the retrieved results. For example, you can query for people in the movies and order the results by the movie name, and then by the actor name. You can sort them in ascending order (from low to high, A to Z, dates in the past, to dates in the future) or descending order (the opposite of ascending).

In the following example, we sort the records by the last name, from A to Z, and after that, a sort on the first name, from Z to A:

SELECT Id, LastName, FirstName FROM Contact ORDER BY LastName ASC, FirstName DESC