/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

0 vote141 views1 answer
Less than date query sqlachemy
SQL
3 votes163 views3 answers
Start postgresql ubuntu
SQL
0 vote139 views2 answers
Sql auto update dupdated_at
SQL
3 votes144 views2 answers
Sql select data from last week
SQL
3 votes138 views1 answer
Mysql set field unique
SQL
1 vote127 views2 answers
Mysql filter by date mount
SQL
0 vote157 views3 answers
Mysql keyword search
SQL
0 vote131 views1 answer
Mysql return column names when table is empty
SQL
5 votes135 views3 answers
How to remove unique key constraint in mysql
SQL
1 vote146 views1 answer
How to copy data of a table from another database to table of anaother database
SQL