1SELECT id,
2 first_name,
3 last_name,
4 FROM customer
5 ORDER BY last_name ASC;
6
1SELECT * FROM table_name ORDER BY col1 ASC; -- ASCending is default
2SELECT * FROM table_name ORDER BY col1 DESC; -- DESCending
3SELECT * FROM table_name ORDER BY col1 DESC, col2; -- col1 DESC then col2 ASC