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 votes209 views2 answers
Add days in oracle sql
SQL
4 votes167 views3 answers
Order by value mysql
SQL
1 vote193 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote194 views1 answer
Limit in access query
SQL
0 vote195 views2 answers
Mysql dump database tables only
SQL
1 vote183 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
5 votes185 views2 answers
Oracle rename table
SQL
1 vote185 views1 answer
Oracle sql first day of year
SQL
-1 vote220 views1 answer
Ms sql select datetime as date
SQL
2 votes187 views2 answers
Mysql show table column comments sql
SQL