You are viewing a single comment's thread. Return to all comments →
select f1.x, f1.y from functions f1 join functions f2 on f1.x = f2.y and f1.y = f2.x where f1.x < f1.y
UNION
select x,y from functions where x = y group by x,y having count(*) > 1
order by x
Seems like cookies are disabled on this browser, please enable them to open this website
Symmetric Pairs
You are viewing a single comment's thread. Return to all comments →
select f1.x, f1.y from functions f1 join functions f2 on f1.x = f2.y and f1.y = f2.x where f1.x < f1.y
UNION
select x,y from functions where x = y group by x,y having count(*) > 1
order by x