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 vote357 views1 answer
Sql server cast date dd/mm/yyyy
SQL
1 vote354 views1 answer
Sql first
SQL
0 vote352 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote373 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote368 views4 answers
Sql rownum
SQL
0 vote356 views1 answer
List all indexes postgres
SQL
0 vote345 views1 answer
Sql datediff month
SQL
10 votes356 views4 answers
How to alter table name in mysql
SQL
15 votes343 views2 answers
Open postgress in terminal mac
SQL
0 vote352 views1 answer
VSCode SQL Server Connection error
SQL