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 vote195 views1 answer
Oracle index hint multiple tables example
SQL
0 vote239 views2 answers
What is 1=2 in sql
SQL
6 votes196 views1 answer
Phpmyadmin password root
SQL
1 vote210 views2 answers
Sql drop multiple columns if exists
SQL
0 vote245 views1 answer
Count number of entires by months sql
SQL
0 vote209 views1 answer
Mysql regex select
SQL
0 vote215 views1 answer
Gcloud sql list databases
SQL
0 vote277 views1 answer
Osm2pgsql mac
SQL
-2 votes206 views2 answers
Union vs union all in sql
SQL
-1 vote214 views1 answer
How to open blade file from blade in laravel
SQL