Re: SQL -- question ...

nik127_at_unm.edu (peter nichola draper) wrote:
> I'm looking for an sql script that deletes duplicate rows.
> Criteria: No unions allowed the table has Megs of data.
> Rows may have all the same fields in them.
>

Will this work? ...

	delete from duprows d
	where  rowid in (
		select rowid
		from   duprows
		where  time = d.time
		and    rowid <> d.rowid
		)
	;

I haven't tried it out ... but I think it's heading in the right direction.

Regards,
- Charles Thompson Received on Wed Apr 05 1995 - 00:00:00 CEST