Horje
order by sql Code Example
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;
order by sql query 
//for accending order
SELECT * FROM TableName ORDER BY ColumnName;

//for descending order
SELECT * FROM TableName ORDER BY ColumnName DESC;
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
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




Related
delete database mysql Code Example delete database mysql Code Example
mysql grant all privileges to a user Code Example mysql grant all privileges to a user Code Example
sql server convert string to date Code Example sql server convert string to date Code Example
mysql delete row Code Example mysql delete row Code Example
sql where contains Code Example sql where contains Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 13



 

Horje