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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-21 : 08:42:37
|
| BLHG writes "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!!!sample table:ID Email Name1 B Ben 2 A Bob3 A Wei 4 D David5 A KenThank you very much." |
|
|
|
|
|
remove duplicate record in my table