How to delete duplicate records from table/query?
Let's say, in a table there are 9 fields fld1 through fld9 and organized/grouped by least occuring to frequent occuring from fld1 - fld9.
If I want to delete all duplicate records that match on fld1, fld2, and fld3. How would I do this?
Let's say, in a table there are 9 fields fld1 through fld9 and organized/grouped by least occuring to frequent occuring from fld1 - fld9.
If I want to delete all duplicate records that match on fld1, fld2, and fld3. How would I do this?