---
title: "Exclude Duplicate Rows (Visual Database Tools) | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: ssms
ms.topic: conceptual
helpviewer_keywords: 
  - "search criteria [SQL Server], excluding rows"
  - "row duplicates [SQL Server]"
  - "duplicate rows"
  - "row excluded in search [SQL Server]"
  - "result sets [SQL Server], duplicate values"
  - "excluding rows"
ms.assetid: ab35a363-421d-4665-946b-ae3f6397af50
author: stevestein
ms.author: sstein
manager: craigg
---
# Exclude Duplicate Rows (Visual Database Tools)
  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 **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  
 [Specify Search Criteria (Visual Database Tools)](visual-database-tools.md)   
 [Sort and Group Query Results (Visual Database Tools)](sort-and-group-query-results-visual-database-tools.md)