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

3 votes126 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
3 votes88 views1 answer
System.debug apex
SQL
0 vote132 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote129 views1 answer
Selects all the columns from the sailors table
SQL
1 vote133 views1 answer
Type int in mysql maxlenght
SQL
5 votes131 views2 answers
Oracle apex debug mode
SQL
2 votes124 views2 answers
Mysql user access to database
SQL
0 vote130 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote142 views1 answer
Is not numeric sql
SQL
11 votes146 views3 answers
Sql line numbers
SQL