Use this page to specify the columns and expressions that you want
to use in the SELECT statement.
You can either select the columns on this page or in the table
graphics in the Tables pane.
- Column
- Select the column or specify the expression to
include in the SELECT statement. To specify an expression, click Build
Expression in the list, and then press Enter to open the Expression
Builder wizard.
- Alias
- An optional field in which you can type an alias
for the column or expression. When you run the statement, alias names
are shown in the result set instead of the column name or expression.
- Output
- If this check box is selected, the column is included
in the result set when the statement is run.
- Sort Type
- Select whether to sort the results for the corresponding
column in ascending or descending order.
- Sort Order
- Select the order in which to sort the results.