The ORDER BY clause: sorting query results

The ORDER BY clause allows sorting of query results by one or more columns. Each sort can be ascending (ASC) or descending (DESC). If neither is specified, ASC is assumed.

 A simple example
 Sorting by more than one column
 Using the column position
 ORDER BY and NULL
 ORDER BY and case sensitivity

Explicitly limiting the number of rows returned by a query
ORDER BY and GROUP BY