Sorting output items

You can specify that data in each output column is sorted in ascending or descending order, and specify the order in which the columns are sorted. The sort order does not affect the display sequence of the output columns.

To specify how the data in a query is sorted:

  1. Click the Sort Options icon in the Output pane of the Query & Analysis Query Definition dialog.
  2. For each column to be sorted, click in the Sorting Type field and select a sorting option.
  3. Click the Top, Up, Down, and Bottom icons in the toolbar to specify the order in which to sort the columns.
  4. Specify whether the query should return all rows, a specified number of rows, or a specified percentage of rows.
Related topics
Relational queries - Query & Analysis Query Editor