ORDER BY Details

Database Guide : Database Help : Database windows and dialogs : SQL clause editors : ORDER BY Details

ORDER BY Details

Use the ORDER BY Details window to specify the ORDER BY clause of a SELECT statement. The ORDER BY clause is also referred to as the "sort by" clause.

Note:

The ORDER BY clause will be removed from the SQL statement if you select Apply without specifying any columns.

Fields

• Columns

• ORDER BY sequence

Push buttons

Select Apply to accept the ORDER BY clause and close the window.

Tasks

• Specifying an ORDER BY clause

Opening the ORDER BY Details window

You can get to the ORDER BY Details window from the SELECT Detailswindow by doing the following:

1. Make sure you have selected the tables and views you want to include in the FROM clause of the SELECT statement.

2. Make sure you have selected the columns you want to include in the SELECT clause of the SELECT statement.

3. From the Clause pull-down menu, select ORDER BY.

Last modified date: 01/29/2015