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 vote142 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
14 votes151 views3 answers
Sql trim from string
SQL
0 vote156 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote157 views1 answer
Mysqlimport
SQL
0 vote160 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote146 views1 answer
Run mssql server terminal
SQL
0 vote187 views1 answer
Inner join distinct
SQL
1 vote138 views1 answer
Reutrn string after character sql
SQL
5 votes146 views2 answers
Copy data from one database to another
SQL
11 votes152 views6 answers
Mysql else if
SQL