How to Sort a Column's Data

Sometimes, you may find it easier to examine the results of your query if the information appears in a certain order. This topic shows you how to sort the data in a column so that the information displays in a specific order


By default, no column's data is sorted. If desired, you can sort a column's data in one of two ways:

        Ascending order: arranges the information in increasing order.

        Descending order: arranges the information in decreasing order.

Applying a Sort to a Column's Data

The following procedure shows you how to apply a sort to a column's data.

  1. In the Results Column panel, position your cursor on the column whose data you want to sort. Slide your cursor to the left until you see this button: .

For example:

  1. Click to display this menu:

  1. The sort order options are in the first group. Select one:

An icon appears next to the column's name to indicate that the sort function is applied. The direction of the arrow on the icon indicates the direction of the sort: ascending or descending.

Now, when you run the query, results for the column display in the Query Results panel in the order you specified.

Removing a Sort from a Column's Data

If a sort is currently applied to a column's data, one of these icons is displayed next to the name of the column in the Result Columns panel: ascending or descending. The direction of the arrow on the icon indicates the direction of the sort.

To remove a sort from a column:

  1. Click the icon to display this menu:

 

  1. Select the Not sorted option.

The sort icon is removed from the column to indicate that the sort is no longer applied to the column's data.  

 

 
Related Topics

How to Create a New Query

 

 

 

<Back to top>