• What is the goal? A set of rows with no duplicates? If so, would you want the row with the max ID? the min ID?

    Most importantly, what have you tried so far?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato