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 votes164 views4 answers
Show sql server database
SQL
0 vote160 views1 answer
Postgres add prefix to primary key
SQL
0 vote171 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote174 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote223 views1 answer
Sql delete caracter list
SQL
2 votes208 views6 answers
In operator in sql
SQL
0 vote205 views1 answer
Sql select merge multiple values
SQL
0 vote143 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote186 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote178 views1 answer
Select odd records sql
SQL