Symmetric Pairs MediumSQL (Intermediate) – HackerRank Solution SQL, Best and Optimal Solutions , All you need.
Solutions of SQL all HackerRank:
Here are all the Solutions of All of SQL of Hacker Rank , Leave a comment for similar posts
SQL Symmetric Pairs MediumSQL (Intermediate) HackerRank Solution
WITH NumberedPairs (R, X, Y)
AS
(
SELECT ROW_NUMBER() OVER (ORDER BY X) AS R,
X, Y FROM Functions
)
SELECT
DISTINCT X,
(SELECT X FROM NumberedPairs WHERE FOuter.X = Y AND X = FOuter.Y AND R <> FOuter.R)
FROM NumberedPairs AS FOuter
WHERE
EXISTS(SELECT Y FROM NumberedPairs WHERE FOuter.X = Y AND X = FOuter.Y AND R <> FOuter.R) AND
X <= (SELECT X FROM NumberedPairs WHERE FOuter.X = Y AND X = FOuter.Y AND R <> FOuter.R)
ORDER BY X;
SQL (Basic)
SQL (Intermediate)
SQL (Advanced)
Basic Select
Advanced Select
Aggregation
Basic Join
Advanced Join
Alternative Queries
Leave a comment below