Medium 6

 avatar
Manishyadav514
mysql
4 years ago
263 B
4
Indexable
SELECT x, y FROM functions f1 
WHERE EXISTS(SELECT * FROM functions f2 WHERE f2.y=f1.x 
AND f2.x=f1.y and f2.x>f1.x) and (x!=y) 
UNION 
SELECT x, y from functions f1 WHERE x=y and 
((SELECT count(*) FROM functions WHERE x=f1.x and y=f1.x)>1)    
ORDER BY x;
Editor is loading...