You are viewing a single comment's thread. Return to all comments →
A little bit shorter solution:
select distinct s.x, s.y from Functions s, Functions s1 where s.x = s1.y and s.y = s1.x and s.x <= s1.x and s.rowid <> s1.rowid order by s.x;
Symmetric Pairs
You are viewing a single comment's thread. Return to all comments →
A little bit shorter solution:
select distinct s.x, s.y from Functions s, Functions s1 where s.x = s1.y and s.y = s1.x and s.x <= s1.x and s.rowid <> s1.rowid order by s.x;