SELECT DISTINCT * FROM foobar f1 WHERE NOT EXISTS ( SELECT * FROM foobar f2 WHERE f1.a = f2.b AND f1.b = f2.a AND f2.a < f2.b )