/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 vote197 views1 answer
Hashpass
SQL
0 vote224 views1 answer
Mysqldump: error:
SQL
0 vote181 views1 answer
Raiserror nowait sql server
SQL
3 votes229 views2 answers
Check data in table mysql
SQL
0 vote196 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
2 votes198 views2 answers
Enable foreign key checks postgres
SQL
20 votes178 views2 answers
Mysql bigint max value
SQL
0 vote182 views1 answer
Print intervals of 15 minutes in sql query
SQL
4 votes207 views2 answers
Oracle unlock account
SQL
1 vote213 views1 answer
Round one decimal place mysql
SQL