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 vote193 views1 answer
Sqlite get date only
SQL
23 votes174 views1 answer
How remove column in mysql
SQL
0 vote153 views1 answer
Drop all tables in azure sql database
SQL
51 votes280 views6 answers
Opera gx
SQL
1 vote170 views1 answer
Alter add syntax
SQL
14 votes176 views2 answers
Install mysqldump
SQL
1 vote187 views2 answers
Select only columns that are not empty oracle sql
SQL
3 votes157 views1 answer
Oracle revoke grant
SQL
0 vote158 views1 answer
Mssql current date
SQL
1 vote175 views1 answer
Postgres start database on linux
SQL