Mysql order by multiple columns

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;		-- col1 DESC then col2 ASC

Ascending order mysql

  
 SELECT 
   column_name1, column_name2, column_name3
FROM 
   table_name
ORDER BY 
   column_name1 [ASC|DESC], 
   column_name2 [ASC|DESC],
   ...;

Source: mysqltutorial.org

Similar codes

21 votes106 views7 answers
Table drop if exist sql server
SQL
2 votes123 views1 answer
Can you use a where clause for a child query
SQL
28 votes133 views4 answers
Show tables mysql
SQL
5 votes138 views3 answers
Postgres show databases
SQL
1 vote121 views1 answer
Oracle sql assign unique number to each grouping
SQL
5 votes160 views2 answers
Mysql where in array
SQL
0 vote129 views1 answer
Initcap in sql
SQL
2 votes143 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
19 votes131 views1 answer
Sqrt(-1)
SQL
0 vote138 views1 answer
Trigger value from maltiple table to single table mysql
SQL