/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 vote207 views1 answer
T sql check active deadlock
SQL
0 vote152 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
6 votes208 views2 answers
Drop foreign key
SQL
0 vote193 views1 answer
How to check if there is no database schema
SQL
1 vote208 views1 answer
How to group by month using sql server
SQL
0 vote201 views1 answer
Postgres where
SQL
11 votes339 views2 answers
Import mysql dump command line windows
SQL
0 vote235 views1 answer
Sql grant select only
SQL
0 vote208 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
4 votes203 views1 answer
Oracle select first 10 rows
SQL