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

5 votes156 views1 answer
Mysql created at yesterdau
SQL
0 vote123 views1 answer
TSQL convert csv to table
SQL
0 vote125 views1 answer
Sql select first and last record of each group
SQL
0 vote55 views1 answer
FindAllBy
SQL
0 vote109 views1 answer
Update top 100 order by sql server
SQL
123 votes296 views5 answers
Sql where contains
SQL
1 vote119 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote119 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote112 views2 answers
Dbms interview questions
SQL
2 votes119 views4 answers
List databases in sql server
SQL