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/
