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

Re: duplicates query

From: gazzag <gareth_at_jamms.org>
Date: Thu, 05 Jul 2007 03:44:43 -0700
Message-ID: <1183632283.754109.299760@57g2000hsv.googlegroups.com>


On 5 Jul, 11:24, colmkav <colmj..._at_yahoo.co.uk> wrote:
> 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.

Post the table DDL together with some sample data and someone will be more able to help.

HTH -g Received on Thu Jul 05 2007 - 05:44:43 CDT

Original text of this message

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