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 vote169 views1 answer
Sql waitfor
SQL
6 votes153 views2 answers
Foreign key sqlite3 python
SQL
0 vote148 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
2 votes164 views3 answers
Sql interview query questions
SQL
0 vote146 views1 answer
Mysql export search results
SQL
6 votes135 views4 answers
Eloquent to sql with bindings
SQL
1 vote156 views1 answer
Oracle enable job
SQL
0 vote149 views1 answer
Mysql update from n to 100
SQL
0 vote145 views1 answer
Oracle last connection
SQL
1 vote166 views2 answers
Sql where is not number
SQL