| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to clean up duplicate records
On Thu, 17 May 2001, tom_at_sqlman.com wrote:
> DELETE FROM tabname WHERE pk_column IN (
> pk1, pk2, pk3);
This won't work for Ewong because his rows are identical. Your way would delete all rows, when Ewong needs all rows but one deleted. You need to resort to Sybrand's way, which takes into account the rowid as well.
-- Galen I don't want to be the rock. Yeah, okay, what do you want to be? I want to be the piece of glass.Received on Fri May 18 2001 - 20:59:25 CDT
 |
 |