[GIS] Select Duplicates in ArcMap Attribute Table

arcgis-10.2arcgis-desktopfile-geodatabasesql

I am trying to select duplicates from a feature class in a file geodatabase using the ArcMap Attribute Table. The query I am using is: 

Address_ID In (SELECT Address_ID FROM "FoodRoutes_20180615" GROUP BY Address_ID HAVING Count(*)>1 )

It is returning an invalid SQL statement error. Do the table or field names need to be in brackets? Anything I may be missing? I also tried the table name without " " and received the same error.

Best Answer

I think a two step quick and dirty way of doing this is as follows:

  1. (OPTIONAL IF THE OVERLAPPING FEATURES ARE PERFECTLY OVERLAPS) Self-union your data (pick your data as the only input)
  2. Run Spatial Join tool by selecting ARE_IDENTICAL_TO match operator
Related Question