HowTo: Query for duplicate records in a feature class table
| Article ID: | 26332 |
|---|---|
| Software: | ArcGIS - ArcEditor 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3 ArcGIS - ArcInfo 8.0.2, 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3 ArcGIS - ArcView 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3 |
| Platforms: | N/A |
Summary
Instructions provided describe how to query for duplicate records within a geodatabase feature class table.
If the procedure below is done on a versioned ArcSDE feature class, the features stored in the delta tables are not considered. Because this query looks only at the business table of a feature class, please ensure all edits have been compressed before running this query. Please see article 29160 in the Related Information section below for details about achieving a full compress and move edits from the delta tables to the business table.
If the procedure below is done on a versioned ArcSDE feature class, the features stored in the delta tables are not considered. Because this query looks only at the business table of a feature class, please ensure all edits have been compressed before running this query. Please see article 29160 in the Related Information section below for details about achieving a full compress and move edits from the delta tables to the business table.
Procedure
Follow the steps below.
- Add feature class to ArcMap.
- Click Selection > Select by Attributes from the Main Menu.
- Copy the following SQL statement into the section labeled 'SELECT *FROM [TABLE_NAME] WHERE:'.
[FIELD_NAME] In (SELECT [FIELD_NAME] FROM [TABLE_NAME] As Tmp GROUP BY [FIELD_NAME] HAVING Count(*)>1 )
Replace FIELD_NAME and TABLE_NAME as necessary.
Related Information
- Compress a versioned database to state 0
Instructions provided describe how to compress a versioned database to state 0. The objective of a compress is to delete non-referenced states, combine states that share the same lineage, and move rows from the delta tables into the base tables. I...
Created: 2/20/2004
Last Modified: 8/26/2008.
http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=26332&td=1