At 10:14 AM 7/6/2009, Bill Niehaus wrote:
I am trying to remember the syntax for finding duplicate
records in a table based on a specific column.
Does someone recall the select command to do such a task?
Bill,
Did you know that you can use the "Duplicates ..." option
to find the duplicates while browsing/editing the data in
Data Browser/Editor?
Here's how:
01. Start RBG76, RBG8, or RBG90
02. CONNECT RRBYW14, RRBYW15, or RRBYW16
03. Database Explorer | Tables ...
04. Double-click on the desired table to open Data Browser
05. Select/highlight the appropriate column
06. Right-click for speed menu and select Calculate ...
Click on "Duplicates..." to find duplicates, if any.
That's all there is to it!
Very Best R:egards,
Razzak.
