Skip to main content
Question

Special duplicate removal

  • April 23, 2026
  • 1 reply
  • 27 views

katta
Contributor
Forum|alt.badge.img+2

Hi, 
I have the following table. I want to remove all records which have a value 2 equal to value 1 of another record and a value 1 equal to value 2 of another record.

I highlighted in blue the ones I would like to remove as they match the removal criteria, e.g. id no 4 is matching criteria when compared to id 1.

What is the easiest way to remove them ? Thx.

1 reply

ebygomm
Influencer
Forum|alt.badge.img+48
  • Influencer
  • April 23, 2026

One possible way