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 vote267 views1 answer
Consulta alias con inner join
SQL
0 vote172 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote264 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote181 views1 answer
Find usage of table in sql server
SQL
1 vote200 views3 answers
Epoch to datetime
SQL
2 votes200 views5 answers
Eloquest how to select one specific column in database
SQL
1 vote210 views1 answer
Apex select list ORA-20999
SQL
0 vote182 views2 answers
Insert into
SQL
0 vote201 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote181 views1 answer
Mysql get 2nd value in comma separated list
SQL