Symmetric Pairs - Medium
https://www.hackerrank.com/challenges/symmetric-pairs/problem
SELECT X, YG
FROM Functions
WHERE X=Y
GROUP BY X,Y
HAVING COUNT(*)>=2
UNION
SELECT s1.X, s1.Y
FROM functions AS s1
INNER JOIN functions AS s2 ON s1.X = s2.Y AND s1.Y = s2.X
WHERE s1.X < s1.Y
ORDER BY X
'기존학습자료 > leetcode, hackerrank' 카테고리의 다른 글
| Leetcode 181 - Consecutive Numbers (0) | 2023.06.25 |
|---|---|
| 해커랭크 - Type of Triangle (CASE) (0) | 2023.06.25 |
| 해커랭크 - INNER JOIN, LEFT JOIN (0) | 2023.06.25 |
| 해커랭크 - 올림/내림/반올림, 절대값/제곱/제곱근 (0) | 2023.06.25 |
| 해커랭크 - 집계함수 (0) | 2023.06.25 |