Searching duplicate records with different unique ids

[Fabian Eschrich]

Hi,

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



Mit freundlichen Grüßen / kindly regards,

Fabian Eschrich
FAESCH Software

info at faesch.de
 
Fon:     +49 (0)37206 889293
Fax:     +49 (0)37206 889294
Skype:   feschrich