You are viewing a single comment's thread. Return to all comments →
select a.x, a.y from functions a join functions b on a.y=b.x and a.x=b.y group by a.x, a.y having (count(*)>1 and a.x=a.y) or a.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 a.x, a.y from functions a join functions b on a.y=b.x and a.x=b.y group by a.x, a.y having (count(*)>1 and a.x=a.y) or a.x