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 -> duplicates query

duplicates query

From: colmkav <colmjkav_at_yahoo.co.uk>
Date: Thu, 05 Jul 2007 03:24:30 -0700
Message-ID: <1183631070.086279.221230@w5g2000hsg.googlegroups.com>


How can I return the list of duplicates that occur in a table?

For example I have 9996 distinct books in a table of 10000 records and I want to know which 4 are repeated. Received on Thu Jul 05 2007 - 05:24:30 CDT

Original text of this message

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