Untitled

 avatar
unknown
plain_text
4 years ago
258 B
3
Indexable
SELECT A.X, A.Y FROM Functions AS A 
WHERE A.X = A.Y AND
(SELECT COUNT(*) FROM Functions WHERE X = A.X AND Y = A.Y) > 1
UNION
SELECT A.X, A.Y from Functions AS A
WHERE EXISTS(SELECT X, Y FROM Functions WHERE A.X = Y AND A.Y = X AND A.X < X)
ORDER BY X;
Editor is loading...