/SQL/Mysql order by two columns priority

Mysql order by two columns priority

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

Similar codes

1 vote228 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote154 views0 answer
SQL
0 vote171 views1 answer
Resullt all update knex mysql
SQL
0 vote198 views1 answer
Html css mobile menu arrow dropdown
SQL
4 votes184 views3 answers
Count with where
SQL
0 vote171 views1 answer
Sql server set complex constraints
SQL
0 vote178 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote175 views1 answer
Sql datediff month
SQL
0 vote174 views2 answers
Psql commande \gset
SQL
4 votes192 views1 answer
List tables sqlite
SQL