Home » Developer & Programmer » Forms » Searching for duplicates on many fields
Searching for duplicates on many fields [message #79173] Thu, 09 May 2002 14:59 Go to next message
Gnosis666
Messages: 1
Registered: May 2002
Junior Member
My particular problem is finding duplicates in a table, but the number of fields which must match to qualify two recs as duplicates is large (up to 20). Is there a particularly clever way around this problem?
Re: Searching for duplicates on many fields [message #79177 is a reply to message #79173] Fri, 10 May 2002 03:32 Go to previous message
nik
Messages: 55
Registered: January 2002
Member
hi !
what about this one ? This may help;

select col1,col2,col3,col4........col20,count(*)
from tab
group by col1,col2,col3,col4(all the way to col20)
having count >1

n
Previous Topic: Rename a file in forms
Next Topic: Development tool
Goto Forum:
  


Current Time: Mon Nov 23 16:58:33 CST 2020