Razzak, Clive, Marc, Tony & Lena, Thanks very much for all of your suggestions. I will get back on to this soon and see what I can do to make this work.
I appreciate your help. Thank you. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, 23 April 2015 1:29 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Detecting duplicate values in a table At 08:26 AM 4/22/2015, John Docherty wrote: >I would appreciate some advice on how to detect duplicate values for a >column in a table. Apart from using a cursor to go through each row and >then looking for rows with the same value is there any quicker way of doing this ? > >Any suggestions would be appreciated. John, Here are a few approaches to find "Duplicate Values" for a column in a table: 01. Database Explorer | Tables | Open Table ... Select the column by clicking on the column cell Main Menu | Calculate | Duplicates ... That will provide you with a list of duplicate values along with a count Results can be printed to Printer, Text File, PDF File, or Clipboard 02. Database Explorer | Tables | Open Table ... Select the column by clicking on the column cell Right-Click | Calculate | Duplicates ... That will provide you with a list of duplicate values along with a count Results can be printed to Printer, Text File, PDF File, or Clipboard 03. Use the HAVING clause of the SELECT command. HELP HAVING Have fun! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 32 years of continuous innovation! 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
