SQL ORDER BY

---

The SQL command ORDER BY orders the results from data returned by SELECT

It can sort by ascending (ASC) or descending (DESC) order.

SELECT fields FROM tablename ORDER BY field <order>