Re: !! URGENT - need Help !!

Hi..
 Simply run this query to remove the duplicae entries......

  delete from <table_name>
  where rowid IN ( select MIN(ROWID) from <tabe_name>

                 group by <field_names>
                 having count(*)>1);

• FOr additional similar queries see www.oramag.com

Best of Luck..
dvsingh_at_amsoftindia.com

In article <6voeok$1al6$1_at_grapool30.rz.uni-frankfurt.de>,   "Mathias Dehm" <dehm_at_stud.uni-frankfurt.de> wrote:
> Hello,
>
> i have many tables in a O8-database which have duplicate entrys. This
> happens because the IMP80-tool runs twice for these tables. Until now, there
> are no constraints on this tables.
>
> An error occurs while creating an primary key because there are duplicate
> entrys.
>
> How can i delete these duplicate entrys from these tables ?
>
> Did anyone know an easy way to do this work?
>
> Thanks a lot
> Mathias
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 12 1998 - 03:55:30 CDT