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

12 votes341 views6 answers
Change mysql root password
SQL
3 votes279 views1 answer
Search for column name in psql
SQL
0 vote306 views1 answer
T-SQL Create Trigger
SQL
0 vote283 views1 answer
Sql inserted
SQL
2 votes285 views1 answer
Mysql time ago difference
SQL
0 vote284 views1 answer
Oracle index hint
SQL
5 votes324 views4 answers
Traduction
SQL
0 vote282 views1 answer
How to save data in database in mysql node
SQL
9 votes283 views4 answers
Add primary key to existing table sql
SQL
1 vote317 views3 answers
Sql union
SQL