Extracting Duplicate Data (kind of ) 1

[jestrada101]

TABLE_A
-------
FieldA - Primary Key
FieldB
FieldC
FieldD
FieldE - A Summary Field
FieldF - A summary Field

In this data, aside from FieldA, there is duplicates. FieldA is unique, but columns FieldB, FieldC and FieldD are identical. How can I determine which FieldA's match? The summaries in both are different.

Hope that makes sense.

Jose E

 

[carp]

If I understand you correctly, you need to a list of FieldAs for rows that contain duplicate FieldB, FieldC, and FieldD values. If so, then try

SELECT FieldA, FieldB, FieldC, FieldD
  FROM my_table
 WHERE (FieldB, FieldC, FieldD) IN 
          (SELECT FieldB, FieldC, FieldD
             FROM my_table
            GROUP BY FieldB, FieldC, FieldD
            HAVING count(*) > 1)
          )
ORDER BY 2,3,4,1;

Doubtless there will be better solutions following soon, but this should at least get you started.

 

[jestrada101]

Thanks! That's what I needed.