Feedback

  • Contents
 

SQL Author

Use SQL Author to create and store custom SQL statements. The system generates SQL statements based on the settings you specify and displays them in the lower section of the SQL Author window. You can save these statements for use in other query tools or programs. 

SQL Author window

  1. Toolbar: Provides options for clearing, opening, saving, and running selection criteria, and counting the query results.

Option

Description

Clear icon

Clears all query settings currently displayed in the window.

Open icon

Clears the query settings currently displayed in the window and opens a saved query.

Save icon

Saves the query settings currently displayed in the window.

Count icon

Sums the number of records that match the selection criteria.

  1. Data Selection pane: Provides a list of data you can select to create a query.

  2. Select Columns pane: Allows you to select and arrange the columns of data to display in the query results.

  3. Conditions pane: Allows you to set the conditions for retrieving data.

  4. Order pane: Allows you to set the order for displaying or running data.

  5. SQL statement section: Displays the SQL statement based on the conditions, columns, and order specified.

Related Topics

Create a SQL Statement

Aggregate Functions

Queries

Query Tools