Searching duplicate records with different unique ids

[Ruslan Zasukhin]

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]