Sorting a data set
Sorting a data set orders the rows in a data set. A SQL query that includes an Order By clause returns a data set sorted using values in one or more columns included in the Order By clause. Sort supports sorting a data set by creating an Order By clause in a SQL query that you create or customize.
For example, consider a data set, containing customer order data, that includes a productName column. To sort the data set rows by product name in ascending order, add the following clause to the SQL query that returns the data set:
Order BY productName ASC

Additional Links:

Copyright Actuate Corporation 2012