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

This message: [ Message body ]
Next message: Alexander Smirnov: "Re: calling stored procedure with an array parameter using Oracle Object for OLE (OO4O)"
Previous message: colmkav: "duplicates query"
In reply to: colmkav: "duplicates query"
Next in thread: Charles Hooper: "Re: duplicates query"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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