Please enable JavaScript to view this site.

ESL Documentation

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.

OrderBy

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.