>How do you remove duplicates in a table? Can this be done without using a second table?

Anthony,

The difficult part of this is determining what constitutes a duplicate record. Is it a record that has the exact same contents in all fields? Or is it some other definition?