/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 vote272 views1 answer
Create sqlite database in laravel
SQL
1 vote308 views1 answer
Sql server loop over query
SQL
7 votes301 views1 answer
Mysql iif
SQL
3 votes287 views1 answer
Oracle user privileges
SQL
0 vote273 views1 answer
Json not contains mysql
SQL
0 vote283 views1 answer
Check sql database table lock
SQL
0 vote283 views1 answer
Postgresql delete multiple rows
SQL
0 vote335 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
6 votes314 views3 answers
Rename column ORACLE
SQL
6 votes309 views2 answers
Mysql execute file
SQL