OraFAQ Forum: Forms » Searching for duplicates on many fields

Home » Developer & Programmer » Forms » Searching for duplicates on many fields

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Searching for duplicates on many fields [message #79173]

Thu, 09 May 2002 14:59

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?

Report message to a moderator

Re: Searching for duplicates on many fields [message #79177 is a reply to message #79173]

Fri, 10 May 2002 03:32

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

Report message to a moderator

Previous Topic:	Rename a file in forms
Next Topic:	Development tool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 28 19:13:32 CDT 2023