I have a set of data coming in from an API and it appears as though there is some duplication occurring. The difficult part is that the ID field is being duplicated with new values, while the other fields remain identical. I've been trying to work out how to select based on two identical column values and delete any rows where the third column value is different, hopefully leaving just one unique ID. The ID field is a randomly generated text field, so I can't just select the minimum value...could I somehow select it based off text field length or something similar?
Can you provide your table structure (DDL - Data Definition Language) of the table, indicating the columns that have duplicate data, with some sample data, as well as examples of the results you want?