Symmetric Pairs SQl – Hacker Rank Solution

Symmetric Pairs - Hacker Rank Solution
Symmetric Pairs – Hacker Rank Solution

Problem

You are given a table, Functions, containing two columns: and Y.

1443818798 51909e977d 1

Two pairs (X1, Y1) and (X2, Y2) are said to be symmetric pairs if X1 = Y2 and X2 = Y1.

Write a query to output all such symmetric pairs in ascending order by the value of X. List the rows such that X1 ≤ Y1.

Sample Input

1443818693 b384c24e35 2

Sample Output

20 20
20 21
22 23


Symmetric Pairs SQL – Hacker Rank Solution

SELECT X, Y FROM FUNCTIONS F1
    WHERE EXISTS(SELECT * FROM FUNCTIONS F2 WHERE F2.Y = F1.X
    AND F2.X = F1.Y AND F2.X > F1.X) AND (X != Y)
UNION
SELECT X,Y FROM FUNCTIONS F1 WHERE X = Y AND
    ((SELECT COUNT(*) FROM FUNCTIONS WHERE X = F1.X AND Y = F1.X) > 1)
      ORDER BY X;

Disclaimer: The above Problem (Symmetric Pairs) generated by Hackerrank but the Solution is Provided by Chase2Learn. This tutorial is only for Educational and Learning purposes. Authority if any of the queries regarding this post or website fill the following contact form thank you.

Leave a Comment