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 vote219 views1 answer
Dual in db2
SQL
0 vote211 views1 answer
Install sql server in ubuntu 20.04
SQL
6 votes198 views2 answers
If not exists insert sql
SQL
0 vote195 views1 answer
What is SQL data store?
SQL
14 votes189 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote201 views3 answers
How to run sql query
SQL
4 votes189 views3 answers
Sql drop database if exists
SQL
5 votes188 views4 answers
Describe table postgres
SQL
10 votes206 views4 answers
How to alter table name in mysql
SQL
5 votes211 views1 answer
Mysql where one year ago
SQL