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

1 vote259 views2 answers
Procedure pl/sql
SQL
0 vote276 views2 answers
Sql update top 100
SQL
0 vote287 views1 answer
Enable full text search mysql
SQL
3 votes436 views9 answers
Linq to sql converter online
SQL
0 vote312 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote268 views1 answer
Mysql update sequence with order by
SQL
1 vote295 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote300 views1 answer
Sql server information_schema temp tables
SQL
3 votes272 views1 answer
Oracle undo tablespace list by user
SQL
0 vote287 views1 answer
Sql values not in another table
SQL