Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Delete the duplicated ones
I have tried with generic standard syntax to delete the duplicated
rows. But something wrong here, that I did not delete correct number of
duplicated row.
example:
with the table T( col1 varchar2(5), col2 varchar(2));
If I used the query of
delete from T t1
where t1.rowid <> <-- or use ">" ( select min(t2.rowID) from T t2 where t1.col1 = t2.col1 and t1.col2 = t2.col2) )
C Chang Received on Tue Mar 04 2003 - 23:16:37 CST