/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 vote178 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote175 views1 answer
How to find username and password in oracle 18c
SQL
1 vote184 views1 answer
Mysql batch insert
SQL
2 votes189 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
18 votes183 views4 answers
Mysql current date between two dates
SQL
0 vote192 views1 answer
Sqlite trim
SQL
0 vote171 views1 answer
Sql remove non numeric characters
SQL
-1 vote189 views1 answer
Search all database tables for a value sqlserver
SQL
14 votes189 views4 answers
Import database through command line
SQL
3 votes181 views3 answers
Stop mysql ubuntu
SQL