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 vote175 views1 answer
How to connect to mysql in ef 6
SQL
3 votes180 views2 answers
Create schema postgres
SQL
0 vote222 views1 answer
Get initials name in sql
SQL
1 vote164 views2 answers
Sql select only first occurrence
SQL
0 vote168 views1 answer
Mysql Error Code: 1005
SQL
2 votes173 views6 answers
In in sql
SQL
7 votes163 views3 answers
How ot change name of column mysql
SQL
0 vote197 views1 answer
Query to insert image
SQL
0 vote167 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote196 views1 answer
Oracle enable chain
SQL