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 vote172 views1 answer
Replace multiple string in query sql
SQL
0 vote195 views1 answer
Function sum(text) does not exist postgres
SQL
2 votes196 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote186 views1 answer
Mysql update from select on same table
SQL
6 votes178 views3 answers
How to delete table sqlite
SQL
0 vote226 views1 answer
Sql from null to not null
SQL
4 votes190 views1 answer
Create column mysql terminal
SQL
0 vote185 views2 answers
Py sqlite if entry exists
SQL
0 vote202 views1 answer
Sql query use select name inside where clause
SQL
2 votes166 views2 answers
Postgresql date at timezone
SQL