GP tool to select unique rows, break ties using rank fields

[Bud]

ArcGIS Pro 2.9.5; File Geodatabase

I have a standalone table that has rows with duplicate ASSET_ID values.

I want to select a single row per set of duplicates. I want to choose what row to select by using multiple rank fields: RANK_PRIMARY, RANK_SECONDARY, etc.  I would choose to prioritize the values in the rank fields by sorting ascending or descending order.

Could a geoprocessing tool be added that can select unique rows and break ties using rank fields?

[SteveLynch]

have you looked at Find Identical?

[Bud]

@SteveLynch Yes, good point.

If I understand correctly, Find Identical and Delete Identical don't let me prioritize rows using rank fields.