Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Selecting SIMILAR, not the same records (PROBABLE) duplicates

Re: Selecting SIMILAR, not the same records (PROBABLE) duplicates

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 5 Sep 2006 12:30:15 -0700
Message-ID: <1157484615.749716.25610@h48g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US