The SQL Wizard gives you the option to retrieve rows that contain unique column values or rows that contain duplicate column values. For example, suppose you want to query the names and addresses of vendors used to ship orders, but that information is associated with each Order ID in the Orders table. The query will return multiple occurrences of each shipping vendor.
By selecting the option to return Distinct, or unique, rows, the query will return only one occurrence of each shipping vendor, making it much easier to make sense of the information returned.
NOTE: This option is available only when creating an SQL Select statement.
