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!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
