Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Q: Find and delete duplicates, how?

Q: Find and delete duplicates, how?

From: Rune Lysbakken <lysbakke_at_online.no>
Date: Thu, 04 Feb 1999 11:28:58 GMT
Message-ID: <36b983d2.91680772@news.online.no>


I want to create an unique index but I have som duplicate values. I think I can find them with a combination of count, group and having Count ()> 1 but how can I delete so that only one of the duplicates remains?

regds Rune Received on Thu Feb 04 1999 - 05:28:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US