回答編集履歴
1
追記
answer
CHANGED
|
@@ -4,4 +4,14 @@
|
|
|
4
4
|
select *,(select sum(value*(date<@today)) from sales) as sum
|
|
5
5
|
from sales where date=@today;
|
|
6
6
|
|
|
7
|
+
```
|
|
8
|
+
|
|
9
|
+
# 追記
|
|
10
|
+
```SQL
|
|
11
|
+
set @today:='任意の日付';
|
|
12
|
+
select t1.id,t1.item_id,t1.date,t1.value,t2.shokei,t3.gokei
|
|
13
|
+
from sales t1
|
|
14
|
+
inner join (select item_id,sum(value) as shokei from sales where date<@today group by item_id) as t2 on t1.item_id=t2.item_id
|
|
15
|
+
inner join (select sum(value) as gokei from sales where date<@today) as t3 on 1
|
|
16
|
+
where date=@today
|
|
7
17
|
```
|