One table in my database has many duplicate records - I would like to eliminate all but ONE record of each set of duplicates. There is a self-related recommendation with an IF/THEN calculation, but I missing some element of that which identifies the "first" record as an original, and tags the other duplicates differently. what am I missing?
Start Free Trial