Hi ,

would this query work always for deleting the
duplicates


delete from t1 where
rowid not in ( select MAX(rowid) from t1 group by
col1, col2, coln );


________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
Oracle LazyDBA home page