回答編集履歴
2
訂正
answer
CHANGED
|
@@ -1,7 +1,7 @@
|
|
|
1
1
|
相関サブクエリーでの集計
|
|
2
2
|
```SQL
|
|
3
3
|
select id, period
|
|
4
|
-
, (select sum(value) from value_table
|
|
4
|
+
, (select sum(cast(value as integer)) from value_table
|
|
5
5
|
where id=t.id
|
|
6
6
|
and period between t.period and to_char(dateadd(RM, 2, to_date(t.period, 'YYYYMM')), 'YYYYMM')
|
|
7
7
|
) as value
|
1
訂正
answer
CHANGED
|
@@ -3,7 +3,7 @@
|
|
|
3
3
|
select id, period
|
|
4
4
|
, (select sum(value) from value_table
|
|
5
5
|
where id=t.id
|
|
6
|
-
and period between t.period and to_char(dateadd(RM,
|
|
6
|
+
and period between t.period and to_char(dateadd(RM, 2, to_date(t.period, 'YYYYMM')), 'YYYYMM')
|
|
7
7
|
) as value
|
|
8
8
|
from value_table t
|
|
9
9
|
|