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 vote159 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
-1 vote214 views1 answer
Get month and year from date in mysql sequelize
SQL
1 vote158 views2 answers
Restart identity cascade
SQL
0 vote154 views1 answer
How to check default value of column in sql server
SQL
5 votes138 views4 answers
Describe table postgres
SQL
0 vote144 views1 answer
Mysql disable query caching
SQL
3 votes138 views2 answers
Oracle synonym
SQL
-1 vote226 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote141 views1 answer
Postgresql isnull with max
SQL
1 vote168 views2 answers
End mysql command
SQL