Sql 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

Sort order on two columns sql

Sort by multiple column : ORDER BY column1 DESC, column2

Similar codes

0 vote209 views1 answer
Oracle select invalid views
SQL
2 votes232 views1 answer
Revokeprivileges mysql
SQL
14 votes227 views3 answers
Trim sql
SQL
7 votes196 views1 answer
Mysql load data infile csv
SQL
0 vote238 views1 answer
Sql out file formate
SQL
3 votes232 views1 answer
DB: in eloquent using sql
SQL
-1 vote220 views1 answer
How to dump .csv file into mysql
SQL
0 vote223 views1 answer
Join creating duplicate columns sqllite
SQL
1 vote233 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
7 votes234 views3 answers
How ot change name of column mysql
SQL