Untitled
user_9914919852
mysql
4 years ago
144 B
4
Indexable
SELECT A.x, A.y FROM FUNCTIONS A JOIN FUNCTIONS B ON A.x = B.y AND A.y = B.x GROUP BY A.x, A.y HAVING COUNT(A.x) > 1 OR A.x < A.y ORDER BY A.x
Editor is loading...
SELECT A.x, A.y FROM FUNCTIONS A JOIN FUNCTIONS B ON A.x = B.y AND A.y = B.x GROUP BY A.x, A.y HAVING COUNT(A.x) > 1 OR A.x < A.y ORDER BY A.x