Share via


How to: Exclude 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.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.

To exclude duplicate rows from the result set

  1. Right-click the background of the Diagram pane, then choose Properties from the shortcut menu.

  2. In the Property window, click Distinct values and set the value to Yes.

    The Query and View 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 may not be able to modify the result set in the results pane.

See Also

Tasks

How to: Select Rows that Do Not Match a Value

Other Resources

Specifying Search Criteria

Sorting and Grouping Query Results