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.



