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

4 votes387 views6 answers
List all tables in postgres
SQL
0 vote386 views1 answer
Add new column in sql with foreign key
SQL
1 vote341 views2 answers
Login to mysql
SQL
0 vote377 views1 answer
Prisma transaction
SQL
0 vote347 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
4 votes377 views1 answer
Ms sql truncate table vs delete
SQL
20 votes358 views1 answer
Sql change column types
SQL
0 vote341 views1 answer
Show database not empty tables postgres
SQL
3 votes341 views1 answer
Mssql remove column
SQL
10 votes393 views2 answers
Doublon sql
SQL