The ORDER BY Clause

This clause lets results be displayed in ascending or descending order. Keywords:
 ASC - Ascending order.
 DESC - Descending order.
Other Keywords

 ALL - Used to select all records.
 DISTINCT - Used to select unique records. Only unique values are returned.
Example:- SELECT city, state FROM towntable WHERE population > '100000';