목록union (1)

bom's happy life

[SQL 코테] 오프라인/온라인 판매 데이터 통합하기(UNION/UNION ALL/인라인뷰/NULL AS 컬럼명/LIKE/DATE_FORMAT)

A) UNION (SELECT DATE_FORMAT(SALES_DATE, "%Y-%m-%d") AS SALES_DATE, PRODUCT_ID, USER_ID, SALES_AMOUNT FROM ONLINE_SALE AS N WHERE SALES_DATE LIKE '2022-03%' UNION SELECT DATE_FORMAT(SALES_DATE, "%Y-%m-%d") AS SALES_DATE, PRODUCT_ID, NULL AS USER_ID, SALES_AMOUNT FROM OFFLINE_SALE AS F WHERE SALES_DATE LIKE '2022-03%') ORDER BY SALES_DATE, PRODUCT_ID, USER_ID A) FROM절에 인라인뷰 + UNION ALL 사용 SELECT ..
Algorithm💌/프로그래머스 2023. 8. 13. 17:37
이전 Prev 1 Next 다음