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 vote291 views1 answer
Procedure excute monthly oracle
SQL
0 vote261 views1 answer
Truncate table sql server foreign key
SQL
1 vote284 views2 answers
How to combine 2 tables in MySQL
SQL
6 votes284 views2 answers
Postgresql pg_dump
SQL
0 vote298 views1 answer
Create synonym for dblink in oracle
SQL
-1 vote286 views5 answers
Convert sql to linq query online
SQL
6 votes311 views6 answers
Rename column postgres
SQL
0 vote325 views3 answers
Postgres trim string
SQL
0 vote284 views2 answers
Add new column after in sql
SQL
1 vote282 views1 answer
Convert epoch to date in sql server
SQL