Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> delete duplicate recore
hi all
if you have a unique key with col1 + col1, you can use following sql.
delete from table_name a
where a.rowid > (select min(b.rowid) from table_name b
where b.col1 = a.col1 and b.col2 = a.col2 )
if you have any questions, feel free let me know.
bye
from hhchang
mail : h2chang_at_chollian.net
Received on Tue Oct 26 1999 - 18:59:12 CDT