DELETING IDENTICAL ROWS FROM A TABLE

Hi everybody,

Its really great that I got really great responses for my problem

        HOW TO DELETE IDENTICAL ROWS FROM A TABLE I am a beginner.

Most of the answers I got used ROWID to identify rows (which I didn't know) So I also used that to do manipulation for a table.

My version copies the result to a new table

SQL>insert into tab2 (COL_WITH_DUP_VAL, COL2) select COL_WITH_DUP_VAL, COL2 tab1 where rowid in (select min(a.rowid)
from tab1 a, tab1 b
where a.COL_WITH_DUP_VAL = b.COL_WITH_DUP_VAL group by a.COL_WITH_DUP_VAL) ;

This create a new table keeping the original table unaltered.

Thank you Guys
-----SHIVA Received on Fri May 30 1997 - 00:00:00 CDT