TALLY colname FROM tableview WHERE COUNT > 1 ~Claudine ☺
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sharon Lima Sent: Tuesday, October 15, 2002 12:12 PM To: R:Base List Subject: Finding Duplicates Elementary relapse! I know I had this at one time but today I cannot seem to find it or figure it out. I need the command to select all rows from a table where the id# has been used in more than one row. 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. Thanks for help. Sharon ================================================ 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/
