We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Advanced Join
- Symmetric Pairs
- Discussions
Symmetric Pairs
Symmetric Pairs
Sort by
recency
|
1367 Discussions
|
Please Login in order to post a comment
Check out the complete video solution here - https://www.youtube.com/watch?v=kjXGAypRuuE&t=381s
select a.x, a.y from functions A join functions B on a.x = b.y and b.x = a.y group by a.x, a.y
having count(a.x)>1 or a.x < a.y order by a.x;
Check out the complete video solution here - https://www.youtube.com/watch?v=kjXGAypRuuE&t=381s
For MySQL