Re: help:delete duplicated records

Hi
i had this problem before,
my example ist

delete from test t1
where t1.id = (select t2.id

                    from test t2
                    where t1.id=t2.id
                    t1.rowid <> t2.rowid);

ciao
akram jaro

sc schrieb:

> I have a table which has about 20,000 duplicated rows. When I was trying to
> delete it using rowid, it takes for ever to finish, finally I have to cancel
> the query. Could somebody tell me how I should do with it? I can not
> enable PK now for the table.
>
> Thank you for you help.
Received on Mon Oct 09 2000 - 16:22:56 CDT