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 end delete duplicate values?

Q: Find end delete duplicate values?

From: Rune Lysbakken <lysbakke_at_online.no>
Date: Sun, 07 Feb 1999 10:59:50 GMT
Message-ID: <36bd7181.1729686@news.online.no> 





I want to create an unique index but I have some 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? Perhaps I can use rowid? I want a solution that I can use
with many duplicates without a lot of typing!



regds Rune
Received on Sun Feb 07 1999 - 04:59:50 CST












Original text of this message













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