Symmetric Pairs

  • + 1 comment
    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