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

3 votes341 views1 answer
Async await mysql nodejs
SQL
2 votes339 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
20 votes342 views6 answers
Creating a table in sql
SQL
0 vote339 views1 answer
Get enginge db mysql
SQL
0 vote431 views1 answer
How to rename a database in tsql
SQL
6 votes335 views5 answers
Mysql get last insert id
SQL
12 votes337 views2 answers
Update column data type postgres
SQL
4 votes362 views1 answer
Ms sql truncate table vs delete
SQL
0 vote349 views1 answer
Pgsql is not permitted to log in
SQL
1 vote335 views2 answers
How to check if sql query is correct online
SQL