/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

2 votes135 views1 answer
How to find table table in stored procedure sql server
SQL
22 votes138 views3 answers
Year format in date mysql
SQL
0 vote135 views2 answers
Get item by composite primary key mysql
SQL
1 vote141 views2 answers
Sql multiline comment
SQL
2 votes122 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote125 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote141 views1 answer
Sql server convert to guid
SQL
0 vote127 views2 answers
Find lowest number in sql
SQL
0 vote135 views1 answer
Php get closest location by latitude longitude
SQL
0 vote126 views1 answer
Mysql shell ERROR: Not connected.
SQL