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.
  1. Prepare
  2. SQL
  3. Advanced Join
  4. Symmetric Pairs
  5. Discussions

Symmetric Pairs

Sort by

recency

|

1532 Discussions

|

  • gs06sid
     + 0 comments
    WITH
cte AS(
        SELECT *, ROW_NUMBER() OVER(ORDER BY x,y) AS rn
        FROM functions
    )
    
SELECT DISTINCT f1.x, f1.y
FROM cte f1
JOIN cte f2 ON f1.x = f2.y AND f2.x = f1.y AND f1.rn <> f2.rn
WHERE f1.x <= f1.y
ORDER BY f1.x;``

  • nishthawork78
     + 0 comments

    **Check out this video for 10 Solved SQL Hackerrank Solutions - https://www.youtube.com/watch?v=sUMUDJUWDZI **

  • hahayeahnah
     + 0 comments

    MySQL

    with 
    rown as
    (
        select
            x,
            y,
            row_number() over (order by x) idx
        from
            functions
    )
select distinct
    f1.x,
    f1.y
from
    rown f1,
    rown f2
where
    f1.x = f2.y and
    f2.x = f1.y and
    f1.x <= f1.y and
    f1.idx <> f2.idx
order by
    f1.x asc,
    f1.y;

  • redicurrii
     + 0 comments

    SELECT DISTINCT f1.x AS x1, f1.y AS y1 FROM functions f1 JOIN functions f2 ON f1.x = f2.y AND f1.y = f2.x WHERE f1.x <= f1.y group by f1.x,f1.y having (count(x1)>1 and f1.x=f1.y) or (f1.x<>f1.y) ORDER BY f1.x

    i tried this

  • olesatthewheel69
     + 0 comments

    select * from (select * from functions where (y, x) in (select * from functions) and x < y union select * from functions where x = y group by x, y having count(*) = 2) t order by x, y