# Symmetric Pairs SQL Hacker Rank Solution

Hello coders, In this post, you will learn how to solve the Symmetric Pairs SQL Hacker Rank Solution. This problem is a part of the SQL Hacker Rank series.

## Symmetric Pairs SQL Hacker Rank Solution

### Problem

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

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

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.

Sharing Is Caring