Re: Deleting duplicate rows

smblair_at_ edu wrote:

>I know this has been discussed before, but I didn't save the responses the
>first time. Anyway, due to a faulty load program, we have some duplicate
>rows. Can someone offer some suggestions as to how to get rid of the
>duplicates?

The easy one I do is:

create table x_tmp
as select distinct *

     from x;

truncate table x;

insert into x
select * from x_tmp;

regards,
Steve Received on Thu Nov 30 1995 - 00:00:00 CET