You are viewing a single comment's thread. Return to all 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 ``
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 →