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 votes107 views2 answers
Gremove folder from git
SQL
4 votes102 views1 answer
Alter session set nls_date_format
SQL
52 votes265 views6 answers
Rename column sql
SQL
0 vote144 views2 answers
How to login to mysql as normal user in ubuntu
SQL
11 votes110 views1 answer
Sql query to find duplicates in column
SQL
0 vote95 views1 answer
Sqlite to csv statement
SQL
8 votes111 views3 answers
Connect python to mysql
SQL
1 vote125 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote95 views2 answers
Mysql type conversion
SQL
1 vote124 views1 answer
Sql server kill all connections
SQL