I’m having problems removing duplicate records from a database. The DB has about 220,000 records and many records are duplicates. There may be up to 10 or more “identical” records of which I would like to keep 1.
When using selectduplicates in a procedure (after sorting appropriately), I get consistent but incorrect results. I’m expecting about 40,000 - 50,000 unique records, but only end up with several hundred (based on a “select reverse” of the found set from the selectduplicate function).
Any idea what is going on? What, if any, are the limitations of selectduplicates?