/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 votes300 views1 answer
Postgres upsert
SQL
4 votes399 views4 answers
Check constraint in ms sql
SQL
0 vote326 views1 answer
Sql row number in result set
SQL
2 votes357 views2 answers
Get all tables using like
SQL
0 vote328 views1 answer
Mysqldump don't drop table
SQL
0 vote384 views1 answer
Sql server synonym
SQL
1 vote348 views1 answer
Join first name and last name sql
SQL
2 votes342 views1 answer
Sqlite insert if not exists
SQL
0 vote354 views1 answer
Oracle plsql sleep
SQL
0 vote335 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL