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

16 votes411 views3 answers
Get count of duplicate records
SQL
1 vote326 views1 answer
Sql find column name like
SQL
0 vote348 views2 answers
Dumping sql table
SQL
0 vote336 views1 answer
Sql server get date of previous sunday
SQL
3 votes338 views1 answer
Select sequence oracle
SQL
1 vote347 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote328 views1 answer
Postgresql regular expression special characters
SQL
0 vote330 views1 answer
Mysql_union
SQL
2 votes337 views1 answer
Sql update from different table
SQL
11 votes322 views2 answers
Set default column value sql
SQL