(SQL) - LeetCode (easy) 1795. Rearrange Products Table

https://leetcode.com/problems/rearrange-products-table/description/

union all을 사용해본 문제였습니다.

📕 풀이방법

📔 정답 출력 | 반환

기본적인 selection을 store별로 수행해 record들을 합쳐야하므로 union all을 해줘야합니다.

---

📕 Code

📔 ANSI SQL

SELECT product_id, 'store1' AS store, store1 AS price
FROM Products
WHERE store1 IS NOT NULL
UNION ALL
SELECT product_id, 'store2' AS store, store2 AS price
FROM Products
WHERE store2 IS NOT NULL
UNION ALL
SELECT product_id, 'store3' AS store, store3 AS price
FROM Products
WHERE store3 IS NOT NULL

---

*더 나은 내용을 위한 지적, 조언은 언제나 환영합니다.