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 vote298 views1 answer
Oracle sqlp update amount / quantity
SQL
5 votes301 views1 answer
Migrate sql table another database
SQL
5 votes333 views2 answers
Oracle list columns
SQL
0 vote329 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote303 views2 answers
Android sqlite tutorial for beginners
SQL
1 vote349 views1 answer
Nvl postgres
SQL
0 vote297 views1 answer
Ms Sql set us timezone
SQL
0 vote318 views1 answer
Mysql utc timestamp
SQL
1 vote316 views2 answers
Install mysqldump ubuntu
SQL
0 vote313 views1 answer
Sql developer sql worksheet not showing
SQL