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 vote148 views1 answer
How to check database engine in mysql
SQL
0 vote115 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote114 views1 answer
Oracle tablespace autoextend
SQL
2 votes148 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote149 views1 answer
Inner join distinct
SQL
-1 vote167 views1 answer
Minus vs except in sql
SQL
1 vote119 views2 answers
Sql select only first occurrence
SQL
-2 votes138 views2 answers
Union all in sql
SQL
1 vote129 views2 answers
Snowflake alter column data type
SQL
2 votes134 views3 answers
Current setting postgres timezone
SQL