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 vote233 views1 answer
Best sql collation
SQL
4 votes250 views3 answers
Sql drop database if exists
SQL
0 vote228 views1 answer
Sql values not in another table
SQL
16 votes239 views6 answers
Install sqlite3 python
SQL
1 vote177 views2 answers
Get date from datetime postgresql
SQL
0 vote220 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote246 views1 answer
Mariadb change column type
SQL
8 votes258 views1 answer
Mysql dump restore
SQL
0 vote233 views1 answer
Sql stored procedure update if parameter is not null
SQL
1 vote225 views1 answer
Set autoincrement to 0
SQL