Order By Dialog Box

Type directly into the statement box, or use the lists and buttons to build your SQL query.

Finished statement

In this box, add an ORDER BY clause to your SELECT statement to sort the records resulting from the query. You can sort only by fields specified in your SELECT statement.

Functions

Use these SQL functions to perform calculations on fields.

Fields

This box displays the fields in the selected file(s). For more information about a field, hover your mouse over the field name.