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

9 votes346 views1 answer
Mysql check date range
SQL
0 vote337 views2 answers
Sql query for getting details by id
SQL
0 vote329 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote348 views1 answer
Sql check if column exists
SQL
0 vote353 views1 answer
Sql change primary key to composite key
SQL
1 vote343 views4 answers
Aggregate function in sql
SQL
1 vote362 views1 answer
Oracle get current schema
SQL
4 votes361 views4 answers
Date less than in sql
SQL
4 votes1.1K views1 answer
Oracle show errors
SQL
1 vote334 views1 answer
Mysql is odd
SQL