And expanding on Karen's example you can use the resulting list as an argument for an IN clause so that you can review all of the records matching your criteria:
BROWSE * FROM tablename WHERE columnname IN (SELECT columnname FROM tablename GROUP BY columnname HAVING COUNT(*) > 1) This will show you all of the records that contain the duplicate values. _____ From: [email protected] [mailto:[email protected]] Sent: Monday, July 06, 2009 10:57 AM To: [email protected] Subject: [RBASE-L] - Re: Duplicate records SELECT columnname FROM tablename GROUP BY columnname HAVING COUNT(*) > 1 >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? Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
