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 vote356 views1 answer
How to input data as id in database sql c#
SQL
0 vote361 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote401 views1 answer
Postgres rename database
SQL
1 vote349 views1 answer
Postgres get timestamp
SQL
0 vote348 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote407 views1 answer
Sql find gaps in date ranges
SQL
6 votes358 views4 answers
Remove spaces sql server
SQL
0 vote371 views1 answer
Sql put two columns into one
SQL
0 vote367 views3 answers
Sql query checker
SQL
1 vote386 views2 answers
Oracle create synonym
SQL