Ascending order and where in sql

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

1 vote134 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
2 votes127 views1 answer
Mysql sysdate
SQL
0 vote136 views1 answer
Set mysql socket file docker windows
SQL
0 vote158 views1 answer
Pgadmin save data greyed out
SQL
1 vote136 views1 answer
Add many column to sap iq table
SQL
0 vote148 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
1 vote133 views1 answer
Mariadb get column names from table
SQL
1 vote139 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
16 votes131 views2 answers
Mysql date between two dates
SQL
1 vote135 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL