Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Selecting SIMILAR, not the same records (PROBABLE) duplicates
I don't know that this would be the most efficient, but it's quite
simple ... how about adding a where clause to your current statement,
"and t1.rowid < t2.id"
This would eliminate some duplicate, and force the comparison to be "in one direction", leaving out the small problem of reporting sub groups, such as row 3 vs 4.
hth Received on Tue Sep 05 2006 - 14:30:15 CDT