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 vote365 views1 answer
Postgresql function ROUND
SQL
0 vote364 views1 answer
Case insensitive sql
SQL
16 votes329 views2 answers
Gremove folder from git
SQL
0 vote336 views2 answers
Mysql get routine parameter list
SQL
3 votes382 views2 answers
Check data in table mysql
SQL
0 vote354 views1 answer
T-SQL Never ending DELETE
SQL
0 vote423 views3 answers
Postgres trim string
SQL
1 vote341 views1 answer
Local sql server
SQL
8 votes355 views1 answer
Oracle add months to sysdate
SQL
1 vote350 views1 answer
Xampp import sql file command line
SQL