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

2 votes219 views1 answer
Select from array in psql
SQL
4 votes221 views4 answers
Update select mysql
SQL
2 votes206 views1 answer
Oracle sql drop column if exists
SQL
1 vote223 views1 answer
Mysql get latest duplicate rows
SQL
3 votes261 views4 answers
Truncate syntax in sql
SQL
2 votes218 views2 answers
Oracle multiple insert
SQL
0 vote221 views1 answer
Oracle current session details
SQL
7 votes256 views2 answers
Mysql check db size
SQL
0 vote237 views1 answer
Check if string is a number sql
SQL
28 votes211 views4 answers
Mysql delete database
SQL