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
Push buttons
Select Apply to accept the ORDER BY clause and close the window.
Tasks
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