Re: Deleting duplicate rows

Or

create table y_tmp
as select distinct *

     from y;

truncate table y;

insert into y
select * from y_tmp;

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