SELECT [some idnum] GROUP BY [some idnum] HAVING COUNT [some idnum] > 1
Personally, I would dump the idnums into a (temp) table and then refer back to
that to check what you really want to remove.
Regards,
Alastair.
----- Original Message -----
From: Gray, Damon
To: RBASE-L Mailing List
Sent: Tuesday, April 14, 2009 9:08 PM
Subject: [RBASE-L] - Finding Duplicate records
I know I can use Delete Duplicates to blow out these records, but I'd like to
list them out so someone in our accounting department can analyze them. I
don't see a built in method of identifying duplicate records in tables. Does
such a thing exist in 6.5++ ?
wwwww
( @ @ )
-------oOO---(_)---OOo-------
Damon J. Gray
Anvil Corporation Business Services
(360) 937-0770
oooo0 0oooo
( ) ( )
----------\ (----) /-----------
\__) (__/
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.238 / Virus Database: 270.11.56/2058 - Release Date: 04/14/09
06:17:00
