/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

4 votes320 views2 answers
Dbms output
SQL
2 votes312 views1 answer
Sql update \
SQL
0 vote300 views1 answer
Create mysql pool connection python flask
SQL
1 vote349 views2 answers
This month mysql where
SQL
1 vote316 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote302 views1 answer
Opensuse stop MySQL
SQL
1 vote330 views1 answer
Convert to hexadecimal sql
SQL
0 vote318 views1 answer
Add sqlcmd to path linux
SQL
0 vote304 views1 answer
Oracle c# multiple update sql
SQL
1 vote290 views2 answers
Sql where is not number
SQL