/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 votes110 views1 answer
Columns Present in a table
SQL
0 vote129 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
2 votes124 views2 answers
How to check data type in sql server
SQL
0 vote120 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote123 views1 answer
Pgadmin save data greyed out
SQL
0 vote106 views2 answers
Update information in a mysql column
SQL
1 vote111 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote102 views1 answer
Min mysql
SQL
0 vote120 views1 answer
Mysql config slave
SQL
0 vote116 views1 answer
Sql delete dastabase
SQL