Sort Order

In this step of the wizard you can identify how the results from your query should be sorted by identifying one or more columns to sort.

Add SortDisplays the Available Sort Columns window allowing you to select a column to sort by.
Remove SortRemoves the selected column from the sort order.
Sort AscendingChanges the sort direction of the selected column to sort values in ascending order.
Sort DescendingChanges the sort direction of the selected column to sort values in descending order.
Move Column UpMoves the selected column higher in the list of sort columns.
Move Column DownMoves the selected column lower in the list of sort columns.

You can also affect the sort order by right-clicking on a column heading in the preview pane and using the sorting options that appear in the pop-up menu. Changes that you make to the sort order using this method will be reflected on this step.

Note - This step constructs the ORDER BY clause in the underlying SQL statement.