[ORDER BY Order_Item

Specifies the item used to sort the final query result set.

• A field in a FROM table or a subquery. You cannot specify a Blob or General type field.
  
  

  Note:
  If the ORDER BY clause is applied to a UNION operation, the field should also be a Select_Item in the last SELECT clause, not a subquery.

• A field alias from the SELECT list.
  
  

  Note:
  If the ORDER BY clause is applied to a UNION operation, the alias should be a Select_Item in the last SELECT clause.

• A numeric expression indicating the location of the column in the result table. The leftmost column is number 1.
  
  

[ASC]

Specifies an ascending order for the query results. ASC is the default order for ORDER BY.

[DESC]

Specifies a descending order for the query results.

The following code shows a summary of the main clauses of the SELECT - SQL Command:

В	Copy Code
SELECT Select_List FROM Table_List ...[WITH (BUFFERING = lExpr)] [WHERE Conditions] [GROUP BY Column_List] [HAVING Conditions] [UNION Clause] [ORDER BY Column_List] [INTO Clause | TO Clause ] [Additional_Display_Options]

For more information about a particular clause of the SQL SELECT command, see the following topics:

• SELECT Clause
  
  
• FROM Clause
  
  
• SELECT - SQL Command - WITH Clause
  
  
• SELECT - SQL Command - WHERE Clause
  
  
• GROUP BY Clause
  
  
• HAVING Clause
  
  
• UNION Clause
  
  
• INTO or TO Clause
  
  
• Additional Display Options