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 vote302 views1 answer
Python list from sql
SQL
0 vote285 views1 answer
Mysql disable query caching
SQL
0 vote302 views1 answer
How to define a non primary composite key in sql
SQL
0 vote241 views1 answer
Flask_sqlalchemy install
SQL
1 vote289 views1 answer
Simple project for database
SQL
0 vote290 views2 answers
How to set global time_zone in mysql
SQL
0 vote293 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote290 views1 answer
Where date in datetime mysql
SQL
0 vote270 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote273 views1 answer
Mssql current date
SQL