I use this to find charges that may be duplicates but not all the columns are
an exact match
EDIT USING trancpa +
WHERE tr_type = 1 AND (CTXT(custnum)+CTXT(tr_date)+ch_code) IN +
(SELECT (CTXT(custnum)+CTXT(tr_date)+ch_code), COUNT(*) +
FROM tran_daily GROUP BY custnum,tr_date,ch_code +
HAVING COUNT (*) > 1) +
ORDER BY custnum,tr_date,ch_code +
CAPTION '*** Are these charges duplicates? ***'
Marc
From: Gray, Damon
Sent: Tuesday, April 14, 2009 3:08 PM
To: RBASE-L Mailing List
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
( ) ( )
----------\ (----) /-----------
\__) (__/
