回答編集履歴
1
サブクエリの閉じ括弧忘れ修正
answer
CHANGED
|
@@ -9,5 +9,5 @@
|
|
|
9
9
|
SUM(DECODE( CREATED_MONTH, '201903', 1, 0)) SUMMARY5,
|
|
10
10
|
SUM(DECODE( CREATED_MONTH, '201904', 1, 0)) SUMMARY6
|
|
11
11
|
FROM
|
|
12
|
-
(SELECT to_char( CREATED_DTM, 'YYYYMM') CREATED_MONTH FROM TABLENAME A
|
|
12
|
+
(SELECT to_char( CREATED_DTM, 'YYYYMM') CREATED_MONTH FROM TABLENAME) A
|
|
13
13
|
```
|