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.
with cte as (
select row_number() over ( order by x) id, * from Functions
)
select distinct t.x,t.y from cte t
join cte t1
on t.x = t1.y and t.y = t1.x and t1.id <> t.id
where t.x<=t.y
order by 1 asc
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Symmetric Pairs
You are viewing a single comment's thread. Return to all comments →
with cte as ( select row_number() over ( order by x) id, * from Functions ) select distinct t.x,t.y from cte t join cte t1 on t.x = t1.y and t.y = t1.x and t1.id <> t.id where t.x<=t.y order by 1 asc