Untitled

 avatar
user_1196610317
mysql
2 years ago
220 B
1
Indexable
Never
SELECT x,y FROM functions AS f1
GROUP BY x,y
HAVING count(*) >1
UNION
SELECT * FROM functions WHERE x!=y  
AND x in (SELECT y FROM functions WHERE x!=y) 
AND y in (SELECT x FROM functions WHERE x!=y) 
AND x<y
ORDER BY x;