Sharon, I've looked this up since Bernie brought it up and it appears that the COUNT >1 applies to rows in the lookup not the occurrence of the field value.
I apologize for mudding the waters. It's still a quick and dirty way to identify duplicates. But I learned something today, so I'll keep trying... Claudine -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sharon Lima Sent: Tuesday, October 15, 2002 3:37 PM To: [EMAIL PROTECTED] Subject: Re: Finding Duplicates Thank you Bill, this worked perfectly. Claudine, In my RBASE 6.5, the tally you presented did tally but it was not restricted to rows where the number of occurances was greater than one. Thanks to all. Maybe someone else found this useful as well. Sincerely, Sharon ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 1:35 PM Subject: Re: Finding Duplicates > Sharon, > > Select idcolumn, count (*) from tablename + > group by idcolumn + > having count (*) > 1 > > Bill > > On Tue, 15 Oct 2002 13:12:04 -0400, Sharon Lima wrote: > > >For example, I have 25000 rows of data and in a few cases an id# has > been incorrectly used in more that one record. This happened before a > rule was in place but now I want to find the duplicated id#s so pre- > existing data will not be in violation of the rule. > > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
