/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

2 votes266 views1 answer
Merge two columns in sql oracle
SQL
2 votes271 views2 answers
How to rename column name in sql server using query
SQL
0 vote270 views1 answer
Mysql search multiple tables
SQL
8 votes280 views3 answers
Oracle auto_increment
SQL
4 votes311 views6 answers
Select sql
SQL
41 votes354 views6 answers
Alter table add column in SQL Server
SQL
0 vote260 views1 answer
Mysql function variable
SQL
4 votes269 views2 answers
Sql table
SQL
4 votes302 views1 answer
Sql select limit range
SQL
1 vote252 views1 answer
Oracle lowercase
SQL