ORDER BY

ORDER BY is a keyword that allows you to sort a query. It can be sorted in ascending and descending order.

Example

SELECT column1, column2  
FROM Users  
ORDER BY column1 ASC|DESC  

ORDER BY several columns

You can also use ORDER BY to order by several columns. It will order first by first column and if there are multiple records with the same value, it will sort using 2nd column (in the example below).

SELECT column1, column2  
FROM Users  
ORDER BY column1, column2 ASC|DESC