Returning Unique Rows for Your Query

To create a query that returns unique rows using the SQL Wizard:

  1. Run the SQL Wizard and on the Select Operation dialog box, click SQL Select.
  2. Proceed in the SQL Wizard until you reach the Select Columns dialog box.

NOTE: You can only return unique rows for your query in an SQL SELECT statement.

  1. In the Select Columns dialog box, select columns to include in your query.
  1. Select the Return Unique Rows check box.
  2. Click Next to continue creating the query.

- Or -

Click Back to return to the previous screen in the SQL Wizard.

- Or -

Click Finish if the query is done.

See Also