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

3 votes212 views4 answers
Stop MySQL
SQL
0 vote199 views1 answer
Events not working db
SQL
0 vote203 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote201 views1 answer
Is numeric in sql
SQL
21 votes202 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
1 vote216 views2 answers
Procedure syntax
SQL
0 vote203 views1 answer
Como saber si tengo mysql instalado
SQL
2 votes212 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
2 votes257 views1 answer
How to check if a row is null in sql
SQL
4 votes222 views2 answers
Dbms output
SQL