Excluding Duplicate Rows

If you want to see only unique values in a result set, you can specify that you want to exclude duplicates from the result set.

To exclude duplicate rows from the result set

1. Right-click the background of the Diagram pane, then choose Property Pages from the shortcut menu.
   
   
2. In the Query tab of the Property pages window, select Distinct values.

   The Query Designer inserts the keyword DISTINCT in front of the list of display columns in the SQL statement.

   Note   If you use the DISTINCT keyword, you cannot modify the result set in the results pane.

See Also

Selecting Rows that Do Not Match a Value | Specifying Search Criteria | Collapsing Groups of Rows