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 vote329 views1 answer
Show size of all tables postgres
SQL
0 vote457 views1 answer
Postgresql powershell query
SQL
1 vote328 views2 answers
Create a unqie constraint mysql
SQL
5 votes350 views2 answers
Oracle find all tables with column name
SQL
0 vote344 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote306 views1 answer
Truncate table in postgresql and reset id
SQL
2 votes320 views1 answer
Mysql cannot delete or update a parent row
SQL
11 votes347 views2 answers
You are using safe update mode
SQL
0 vote325 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote315 views4 answers
Mysql replace regex
SQL