Remove opposite values

Hi team,

is there anyway, at query level to avoid this:

So basically if the bi-directional record comes out, I'd like to keep 1 only....

Thanks for your help