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 vote179 views1 answer
Set mysql mode global query
SQL
0 vote209 views1 answer
Sql order by except one row
SQL
0 vote185 views1 answer
Show create table in postgresql
SQL
0 vote202 views1 answer
Select into table variable
SQL
1 vote310 views3 answers
Create table from existing table in sql
SQL
1 vote217 views1 answer
Write a query to create an empty table from an existing table?
SQL
3 votes195 views1 answer
Set default today mysql
SQL
0 vote187 views1 answer
Pl sql search saurce code
SQL
0 vote210 views1 answer
Migration graphql
SQL
2 votes193 views1 answer
Get first 2 letter in sql
SQL