I just realized there is a cool new tool called Delete Identical that would work great for me right now. Unfortunately I only have ArcEditor, not ArcInfo. Soooo does anyone have a way I could do this functionality with ArcEditor? I used to use a sql query for duplicate records in a feature class table and I can still use that, but it selects all of them, then I have to go through and delete all but one of the duplicate records.