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 vote376 views1 answer
Date datatype in livesql
SQL
7 votes401 views3 answers
Sql server check if temp table exists
SQL
0 vote361 views1 answer
Sql query tags
SQL
-1 vote424 views5 answers
Left join sql
SQL
2 votes345 views2 answers
Sql first character
SQL
0 vote366 views1 answer
Mssql unique key accept nulls
SQL
0 vote354 views1 answer
Stored function in sql
SQL
13 votes373 views2 answers
Get date from now() mysql
SQL
0 vote363 views1 answer
T-sql email validation
SQL
0 vote382 views1 answer
Psql check table fields
SQL