更新同一表中的重复或类似记录

I have a table that allows records to be inserted which are very similar but differ by a single column value or two. For example the following records are in the table:I have a table that allows records to be insert