My

[SQLD] 기출 틀린 문제 오답정리

37회 [TEST1] COL1 COL2 COL3 ------------------ A X 1 B Y 2 C Z 3 [TEST2] COL1 COL2 COL3 ------------------ A X 1 B Y 2 C Z 3 D 가 4 E 나 5 [SQL] MERGE INTO TEST1 USING TEST2 ON (TEST1.COL1 = TEST2.COL1) WHEN MATCHED THEN UPDATE SET TEST1.COL3 = 4 WHERE TEST1.COL3 = 2 DELETE WHERE TEST1.COL3 > GROUPING SETS(COL1, (COL1, COL2))