Use this dialog box to create an ORDER BY clause for the current multi-row SELECT statement. This clause sorts the rows of your result set.
Columns |
Lists the columns in the select list of the current statement. Select some or all columns.
|
> |
Copies the highlighted columns in the Columns list box to the Order By list box.
|
< |
Removes the highlighted columns from the Order By list box.
|
>> |
Copies all columns in the Columns list box to the Order By list box.
|
<< |
Removes all columns from the Order By list box.
|
Order By |
Lists the columns in the select list of the current statement. The arrow before the column name indicates the sort order of the column. The default is ascending. You can remove columns from this list, move a column up or down, or specify a column's sort order.
|
Up |
Moves the highlighted column up one position in the Order By list box.
|
Down |
Moves the highlighted column down one position in the Order By list box.
|
Asc |
Specifies the sort order of the selected column as ascending.
|
Desc |
Specifies the sort order of the selected column as descending.
|
Apply |
Adds the ORDER BY clause to the current statement and displays it in the SQL Editor window.
|
Close |
Closes the dialog box. If you have not applied the clause, it does not appear in the SQL Editor window.
|
Help |
Displays help for the dialog box.
|
Display this dialog box by selecting SQL Statement>Order by or the Order by button.