Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  How to remove duplication record in my table.

Author  Topic  blhg135 Starting Member 2 Posts Posted - 2001-08-16 : 22:17:05 Hello All SQL guru, Do you have idea how to remove duplication from database looks like the sameple table. All I care is remove those duplicate record if the "Email" field has duplication. Other field have duplication is ok to me. Doesn't matter which record will be remove. There are about 12890 record in the table. If you have any idea. please help!!! table sample: ID Email Name 1 B Ben 2 A Bob 3 A Wei 4 D David 5 A Ken Thank you very much.