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
1SELECT column1, column2, ...
2FROM table_name
3ORDER BY column1, column2, ... ASC|DESCl;