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

16 votes166 views5 answers
Select last row in sql
SQL
0 vote136 views1 answer
Mysql Install Ubuntu with native password
SQL
3 votes143 views1 answer
Oracle list invalid password ORA-01017
SQL
-1 vote140 views3 answers
Create temp table in sql
SQL
27 votes164 views6 answers
Set password mysql
SQL
2 votes139 views1 answer
Drop table if exists in postgres
SQL
0 vote145 views1 answer
Sql: extract day text from datetime value
SQL
-2 votes144 views1 answer
Group functions in sql
SQL
1 vote142 views1 answer
List index mysql cli
SQL
0 vote159 views1 answer
Mysql delete from where like
SQL