sql command to find duplicate records?

qwjunk · January 31st, 2004, 03:13 PM

whats the sql ccommand for finding duplicate records such as say the repeating file numbers in a database ?

Imar · January 31st, 2004, 03:32 PM

Hi there,

There are multiple ways to do this. If you have a simple tabel structure, take a look at this FAQ:
http://imar.spaanjaars.com/QuickDocID.aspx?QUICKDOC=218

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.