Re: Help with cleaning up data

[Bob Eby]

delete b from icd9x10 a
join icd9x10 b on a.icd9 = b.icd9 and a.id < b.id

>...
> CREATE TABLE `ICD9X10` (
> ...
> id   icd9  icd10
> 25   29182 F10182
> 26   29182 F10282
> ...

Good luck,
Bob