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

5 votes232 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
2 votes240 views1 answer
Add 2 hours to current time in MySQL
SQL
2 votes257 views3 answers
Sql server: how to concatenate column data using comma
SQL
3 votes245 views2 answers
Sql end of month
SQL
1 vote237 views1 answer
DATE_SUB postgres
SQL
12 votes213 views4 answers
SQL Where
SQL
0 vote315 views1 answer
ORA-01400
SQL
1 vote240 views1 answer
How to use a trigger to validate input data
SQL
1 vote262 views2 answers
Mysql extract number from string
SQL
0 vote240 views1 answer
How to check xampp mysql password
SQL