/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 vote142 views2 answers
Get date from datetime postgresql
SQL
0 vote157 views2 answers
Insert into
SQL
0 vote185 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote154 views1 answer
Drop all tables in azure sql database
SQL
12 votes187 views1 answer
Run mysql instance in docker
SQL
0 vote162 views1 answer
1 column values in to 1 single row in sql
SQL
3 votes169 views2 answers
Truncate all tables
SQL
8 votes190 views1 answer
My sql version
SQL
-1 vote180 views1 answer
Window functions in sql
SQL
0 vote164 views1 answer
Postgres : ERROR: division by zero
SQL