I think this would tally "ColumnName" _after_ the first row (count > 1)
Ben Petersen On 15 Oct 2002, at 15:07, Claudine Robbins wrote: > Sorry, I tested it before I sent the reply and it does work. ~Claudine > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > On Behalf Of Bernie Corrigan Sent: Tuesday, October 15, 2002 2:54 PM > To: [EMAIL PROTECTED] Subject: RE: Finding Duplicates > > Claudine - > > This does not work. Try testing it. > > Bernie > ---------------------------------------- > At 12:39 PM 10/15/2002 -0500, you wrote: > >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/ > > > ================================================ > 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/
