Order by sql query

Order by sql

//this_for_descending_order.. 
 SELECT * FROM TableName ORDER BY columnName DESC;
 // this_for_ascending_order..
SELECT * FROM TableName ORDER BY columnName ASC;

Sort by 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

Order by sql query

//for accending order
SELECT * FROM TableName ORDER BY ColumnName;

//for descending order
SELECT * FROM TableName ORDER BY ColumnName DESC;

Similar codes

0 vote138 views1 answer
Provide hardcoded value in the mysql query
SQL
23 votes139 views6 answers
Create table sql server
SQL
2 votes183 views2 answers
Mysql date range
SQL
1 vote119 views1 answer
Real world example of nosql
SQL
0 vote125 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote134 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote149 views1 answer
Add mysql database to power bi web
SQL
0 vote123 views1 answer
First Step in installing SQL workbench
SQL
1 vote130 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote140 views2 answers
Py sqlite if entry exists
SQL