How to reorder the columns in your query results
Sometimes, you may want the columns in your query results to display in a specific order. This topic shows you how to make sure they display in the exact order in which you want to view them.
Sections in this article
Default Column Order
By default, the order in which the columns are listed in the Result Columns panel determines the arrangement of the columns in your results set.
How to use the sorting menu to reorder columns
Follow these steps for each column you want to move:
- In the Results Column panel, position your cursor on the name of column you want to move. Slide your cursor to the left until you see this button: .
- Click the button to display this menu:
The column order options are located in the group at the bottom of the menu. Select one of the following:
Move to the first: moves the column to the top of the Result Columns list. After you run the query, this column's results appear first in the Query Results panel.
Move to the previous: moves the column up one position in the list.
Move to the next: moves the column down one position in the list.
Move to the last: moves the column to the last position in the list. After you run the query, this column's results display last in the Query Results panel.
The Results Column panel is immediately updated, and the selected column is relocated in the list.
When you run the query, the columns appear in the Query Results panel in the order you specified.