Claudine, if I never wrote to this list because I am like a politician - I seldom open my mouth except to change feet - I would be invisible. I apologize if my reply sounded pedantic. I was trying to be clear with my explanation, and went overboard. I've seen quite a few helpful posts from you. Check with Sami for my DUH bill at the conference if you think I never make a boo-boo on the list!
Stay loose, and to quote someone I met at a seminar about a month ago - Keep having fun! "Claudine Robbins" <[EMAIL PROTECTED]> wrote: >OK, I'm wrong. �I'll be quiet from now on... Claudine > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >On Behalf Of Albert Berry >Sent: Tuesday, October 15, 2002 3:59 PM >To: [EMAIL PROTECTED] >Subject: RE: Finding Duplicates > >Claudine, your TALLY command will give you the total count of items, >ignoring the first item in the table. WHERE COUNT refers to the row >being looked at. You can select WHERE COUNT = 279, for example. If you >try your tally command without the where count > 1, you will find that >one of the "buckets" in the TALLY has one more item than the first time >you ran it. > >The way I read the question, the user wanted only to see those items >that were duplicates in a list of mainly unique values. �The SELECT ... >GROUP BY ... HAVING COUNT(*) > 1 is the one that works. > > >"Claudine Robbins" <[EMAIL PROTECTED]> 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/ >> > > >-- >Albert Berry >Full Time Consultant to >PSD Solutions >350 West Hubbard, Suite 210 >Chicago, IL 60610 >312-828-9253 Ext. 32 > > >__________________________________________________________________ >The NEW Netscape 7.0 browser is now available. Upgrade now! >http://channels.netscape.com/ns/browsers/download.jsp > >Get your own FREE, personal Netscape Mail account today at >http://webmail.netscape.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/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
