SELECT * FROM table_name ORDER BY col1 ASC; -- ASCending is default SELECT * FROM table_name ORDER BY col1 DESC; -- DESCending SELECT * FROM table_name ORDER BY col1 DESC, col2 ASC; -- col1 DESC then col2 ASC