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/
