You are viewing a single comment's thread. Return to all comments →
WITH NUM AS (SELECT ROW_NUMBER() OVER(ORDER BY X,Y) RN, X,Y FROM FUNCTIONS) SELECT F1.X,F1.Y FROM NUM F1 INNER JOIN NUM F2 ON F1.X =F2.Y AND F1.Y = F2.X AND F1.RN < F2.RN 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 →