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

1 vote133 views1 answer
How to update date add hours in postgresql
SQL
13 votes131 views2 answers
Oracle select into and inner join
SQL
0 vote125 views1 answer
Sql comparison operators
SQL
0 vote139 views1 answer
Django mysqlclient connection string
SQL
9 votes149 views6 answers
Check constraint in sql
SQL
0 vote130 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote136 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
6 votes125 views1 answer
Wordpress change user password sql
SQL
0 vote140 views1 answer
Html css mobile menu arrow dropdown
SQL
1 vote132 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL