목록union (1)

HAZEL

[SQL : HackerRank] UNION

1. Symmetric Pairs >> 문제 You are given a table, Functions, containing two columns: X 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 >> 문제 풀이 SELECT X , Y FROM Functions WHERE X = Y GROUP..
DATA ANALYSIS/SQL 2021. 2. 14. 10:25
이전 Prev 1 Next 다음