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 vote131 views3 answers
Between keyword sql
SQL
8 votes122 views1 answer
Today minus 15 days postgresql
SQL
0 vote156 views2 answers
Cascade syntax in sql
SQL
27 votes146 views3 answers
Mysql show tables in database
SQL
0 vote136 views1 answer
Less than and between in sql query
SQL
1 vote104 views1 answer
Oracle compile schema
SQL
19 votes128 views5 answers
Change column name mysql command line
SQL
1 vote137 views1 answer
Sql first day quarter
SQL
0 vote127 views1 answer
How to select only id where is not in column mysql
SQL
1 vote132 views1 answer
Second last highest id in sql
SQL