Anybody have a SQL example for deleting duplicate records in a table
(deleting all but one)?



Or better yet, one that deletes redundant records that have certain column
values in common, regardless of the values in all other columns? E.g., if
Client_ID, firstname, middlename, lastname are the same, regardless of what
may be in address, city, state, zip, etc. fields, delete the dupes?



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]