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

5 votes349 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote357 views2 answers
Plpgsql
SQL
0 vote339 views1 answer
Get initials name in sql
SQL
0 vote336 views1 answer
How to find lowest in sql
SQL
1 vote366 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
1 vote329 views1 answer
Blob datatype in mysql
SQL
0 vote349 views1 answer
How to select all fieldsin a soql query
SQL
0 vote308 views1 answer
Drop all procedures sql server
SQL
1 vote327 views1 answer
Alter constraint postgres
SQL
0 vote313 views1 answer
Oracle sql winter time change
SQL