/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

5 votes195 views1 answer
Oracle asynchronous procedure
SQL
1 vote237 views1 answer
Psql view enum values
SQL
0 vote198 views1 answer
Drop domain postgresql
SQL
0 vote212 views1 answer
Sqlite3 pragma foreign keys
SQL
-1 vote235 views2 answers
Sql truncate number
SQL
0 vote219 views3 answers
Constraint sql
SQL
0 vote205 views1 answer
Running query in redshift
SQL
0 vote202 views1 answer
Sql last 7 days
SQL
0 vote217 views1 answer
Mysql where don't have string
SQL
1 vote210 views1 answer
Get table column names sql ssms
SQL