You are viewing a single comment's thread. Return to all comments →
SELECT F1.X, F1.Y
FROM Functions AS F1
INNER JOIN Functions AS F2
ON F1.X = F2.Y AND F2.X = F1.Y
WHERE F1.X <= F1.Y
GROUP BY F1.X, F1.Y
HAVING (COUNT(F1.X) > 1 AND F1.X = F1.Y) OR (F1.X <> F1.Y)
ORDER BY F1.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 AS F1
INNER JOIN Functions AS F2
ON F1.X = F2.Y AND F2.X = F1.Y
WHERE F1.X <= F1.Y
GROUP BY F1.X, F1.Y
HAVING (COUNT(F1.X) > 1 AND F1.X = F1.Y) OR (F1.X <> F1.Y)
ORDER BY F1.X;