Database Guide

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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]