Symmetric Pairs

  • + 44 comments

    My MS SQL solution:

    SELECT f1.X, f1.Y FROM Functions f1
    INNER JOIN Functions f2 ON f1.X=f2.Y AND f1.Y=f2.X
    GROUP BY f1.X, f1.Y
    HAVING COUNT(f1.X)>1 or f1.X<f1.Y
    ORDER BY f1.X