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 vote111 views1 answer
Postgres data location
SQL
0 vote82 views1 answer
Mysql timeout 30 seconds
SQL
0 vote114 views1 answer
Select top 3 sql
SQL
0 vote184 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote115 views1 answer
Jooq replace
SQL
50 votes209 views6 answers
Install mysql on ubuntu
SQL
0 vote69 views1 answer
Psql not found windows
SQL
0 vote75 views1 answer
Mysql sleep connections
SQL
1 vote119 views1 answer
Sql select where id not exists in another table
SQL
7 votes115 views1 answer
Mysql remote connection command line
SQL