I have a large polygon layer in which most of the polygons have a unique name in a text field. Of the hundreds that aren't unique, there will be 2-4 polygons with the same name but different geometries. I need to keep one of those polygons in each set of duplicates, the one with the largest area, and delete the rest. Since the geometries are different I'm guessing I can't use ArcGIS' built-in duplicate finder and will need an SQL statement to do what I need but I'm far from proficient with SQL.
Here's how I would do it: