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.