SQL Interview Questions and Answers Series | HackerRank | SYMMETRIC PAIRS | Advanced Join

[@badrilalnagar9232]

I hope that you will get success to your channel.

[@vitorcastro42]

Can anyone explain to me why my solution does not work? with Functions_symmetric as ( select Functions.y as x2, Functions.x as y2 from Functions ), Joined_tables as ( select Functions.x, Functions.y, Functions_symmetric.x2, Functions_symmetric.y2 from Functions inner join Functions_symmetric on Functions.x = Functions_symmetric.y2 and Functions.y = Functions_symmetric.x2 ) select distinct x, y from Joined_tables where x

[@pujankoshti9589]

why you did GROUP BY X,Y in where clause?. what is the use of that?

[@datasciencewithnish]

General Context - We use the GROUP BY clause to categorize data before applying the HAVING clause. The GROUP BY clause groups rows together based on shared values in one or more columns. The HAVING clause then filters these groups based on a condition applied to aggregate functions (e.g., COUNT) in this case. Generally, HAVING allows filtering based on aggregate values, which aren't available until after the data is grouped. For instance, here you can't filter for symmetric pairs with a "COUNT > 1" until the rows are grouped and the count is calculated. So, we've used the GROUP BY just to segregate the pairs.

[@frezerzelalem4017]

@@datasciencewithnish as a follow up, why didn't you used x1

[@Anonymous____________A721]

Why not cross join

[@Mahanthesh.]

Amazing madam

[@shashanksingh4708]

Thanks for sharing your solution . Have a look at mine : select distinct f1.x , f1.y from functions f1 join functions f2 on f1.x=f2.y and f1.y=f2.x where f1.x

[@rajeshin1]

Other way can be like this too right select distinct f1.x , f1.y from functions f1 join functions f2 on f1.x=f2.y and f1.y=f2.x where f1.x1 ) order by f1.x;

[@palnitin25]

Thank you for this Nishtha

[@SumanSadhukhan-md4dq]

This is nice

[@YogeshChaudhary-s8y]

as a follow up, why didn't you used x1

[@harshitgiria7709]

Did you understand why it's happening? Could you please let me know?

[@coc3311]

okey actual problem is that when you use x1

[@harshitgiria7709]

@@coc3311 Yeah Got it ...Thank You for the explanation.

[@lalitranaiitan]

cool

[@YogeshChaudhary-s8y]

as a follow up, why didn't you used x1

[@tanmaynagrale4595]

Same doubt