Sorting page of the SQL designer
The Sorting page enables you to specify a sort order for the query.
To sort query results
Select the field you wish to sort by from the Output Fields list box.
Click the Add button to move the field to the Sorted By list box.
Toggling the sort order
Double click on the field in the Sorted by list box. To change sort order, you may also select the field and then to the left of the list box click on the A-Z for ascending order and Z-A for descending order.
Sorting on multiple fields
Simply add more fields to the Sorted By list box. The query will be sorted based on order of the fields that appear in the Sort By list box.
Adding a field to the Output Fields list box
Select the field in the Table Pane.
Removing a field from the Sorted By list box
Select the field and click the Remove button.
Reordering fields in the Sorted By list box
Select the field to move in the Sorted By list box.
Click on the gray up arrow to left of the list box to move the field up in the sort order. Click on the gray up/down arrow to the left of the list box to move the field down in the sort order.