Symmetric Pairs

  • + 0 comments
    WITH CTE AS (
    SELECT t.X as x1,t.Y as y1,COUNT(*) as cnt FROM (
    SELECT X,Y FROM Functions WHERE X<=Y
    UNION ALL
    SELECT Y,X FROM Functions WHERE Y!=X
    ) AS t
    GROUP BY t.X,t.Y
    HAVING COUNT(*) > 1
    )
    
    SELECT x1,y1 from CTE
    ORDER BY x1
    ``