Q6 Med
unknown
mysql
3 years ago
155 B
2
Indexable
SELECT f1.X, f1.Y FROM Functions f1 INNER JOIN Functions f2 ON f1.X=f2.Y AND f1.Y=f2.X GROUP BY f1.X, f1.Y HAVING COUNT(f1.X)>1 or f1.X<f1.Y ORDER BY f1.X
SELECT f1.X, f1.Y FROM Functions f1 INNER JOIN Functions f2 ON f1.X=f2.Y AND f1.Y=f2.X GROUP BY f1.X, f1.Y HAVING COUNT(f1.X)>1 or f1.X<f1.Y ORDER BY f1.X