Re-2: Searching duplicate records with different unique ids

[Fabian Eschrich]

life can be so easy ;-)
thsnks ruslan

-------- Original Message --------
Subject: Re: Searching duplicate records with different unique ids (15-Jan-2009 11:46)
From:    Ruslan Zasukhin <sunshine at public.kherson.ua>
To:      valentina at lists.macserve.net

> On 1/15/09 12:25 PM, "Fabian Eschrich" <info at faesch.de> wrote:
> 
> Hi Fabian, 
> 
> > I am thinking how to easily find duplicate records in a table (but 
> > different
> > ids).
> > We have an accounting table where payments of invoices are saved and an
> > employee inserted payments twice.
> > 
> > So now I have some duplicate records. Unique id is different for all 
> > records,
> > but a column 'referenceid' is the same for duplicate records.
> > 
> > Has somebody an idea how to do this?
> > 
> > I thought about something with using DISTINCT
> 
> What about 
> 
> SELECT referenceid, COUNT(referenceid)
> FROM T
> GROUP BY referenceid
> 
> 
> 
> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>