I need to select records from the same table that are almost duplicates, except for one field. This query looks to me like it should work, but it really doesn't:
db2 "select some_tin from some.table where field_1 = '13' and field_2 = '01' and field_3 in (select distinct field_3 from some.table where field_1 = '13' and field_2 = '0 ')
Any help would be greatly appreciated,
db2 "select some_tin from some.table where field_1 = '13' and field_2 = '01' and field_3 in (select distinct field_3 from some.table where field_1 = '13' and field_2 = '0 ')
Any help would be greatly appreciated,