Untitled

 avatar
unknown
plain_text
4 years ago
190 B
7
Indexable
SELECT * FROM functions A WHERE EXISTS(SELECT * FROM functions B WHERE B.x>A.x AND A.x=B.y AND B.x=A.y )
UNION 
SELECT * FROM functions WHERE x = y GROUP BY x HAVING count(*) > 1 ORDER BY x;
Editor is loading...