List:General Discussion« Previous MessageNext Message »
From:Bob Eby Date:March 31 2014 2:53pm
Subject:Re: Help with cleaning up data
View as plain text  
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

Thread
Help with cleaning up datawilliam drescher29 Mar 2014
  • Re: Help with cleaning up dataFran Garcia29 Mar 2014
  • Re: Help with cleaning up dataCarsten Pedersen29 Mar 2014
  • RE: Help with cleaning up dataDavid Lerer30 Mar 2014
  • Re: Help with cleaning up datawilliam drescher30 Mar 2014
Re: Help with cleaning up dataBob Eby31 Mar 2014