Sort by sql

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;

Sql reverse order of results

SELECT q.* 
    FROM (SELECT TOP 3 * 
              FROM table 
              ORDER BY id DESC) q
    ORDER BY q.id ASC

Source: stackoverflow.com

Similar codes

1 vote333 views1 answer
How to print longest name in sql
SQL
0 vote360 views1 answer
QCompleter con sql
SQL
14 votes375 views3 answers
How to add default constraint in mysql
SQL
3 votes330 views2 answers
Oracle for loop
SQL
8 votes351 views1 answer
Mac restore mysql database command line
SQL
0 vote335 views1 answer
Install ms sql server management studio
SQL
1 vote370 views1 answer
Increase existing date in sql
SQL
9 votes381 views3 answers
Postgres make sql dump
SQL
0 vote345 views1 answer
Alter owner in PostgreSQL
SQL
0 vote383 views1 answer
Mariadb set vertical output format
SQL