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

0 vote190 views1 answer
Create a table from one field of another table
SQL
0 vote192 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote198 views3 answers
Condition in count sql
SQL
1 vote176 views1 answer
List index mysql cli
SQL
23 votes171 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
7 votes203 views2 answers
How to create index mysql
SQL
0 vote178 views1 answer
Selecting Data in SQL - Select Data
SQL
1 vote162 views3 answers
String to int mysql
SQL
7 votes222 views1 answer
Show line number in sql server
SQL
0 vote220 views1 answer
Create table using the clause with as
SQL