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 vote367 views1 answer
Pl/sql how to delete a trigger
SQL
1 vote375 views1 answer
Create new table from old table
SQL
0 vote388 views1 answer
Postgres list all triggers
SQL
0 vote343 views1 answer
Declarative base sqlalchemy
SQL
0 vote334 views1 answer
View to table
SQL
1 vote333 views1 answer
Import database from a file using mysql commandline
SQL
3 votes379 views1 answer
Sql double index
SQL
1 vote331 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote349 views1 answer
What does leave do in mysql
SQL
0 vote342 views1 answer
Sql find all different values in column
SQL