質問編集履歴
1
テーブルを若干変更。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -1,4 +1,4 @@
|
|
|
1
|
-
##
|
|
1
|
+
## 環境
|
|
2
2
|
|
|
3
3
|
|
|
4
4
|
|
|
@@ -8,7 +8,7 @@
|
|
|
8
8
|
|
|
9
9
|
|
|
10
10
|
|
|
11
|
-
##
|
|
11
|
+
## 目的
|
|
12
12
|
|
|
13
13
|
|
|
14
14
|
|
|
@@ -16,9 +16,9 @@
|
|
|
16
16
|
|
|
17
17
|
|
|
18
18
|
|
|
19
|
-
```
|
|
20
19
|
|
|
20
|
+
|
|
21
|
-
### ItemTable
|
|
21
|
+
#### ItemTable
|
|
22
22
|
|
|
23
23
|
-----------------
|
|
24
24
|
|
|
@@ -36,7 +36,7 @@
|
|
|
36
36
|
|
|
37
37
|
|
|
38
38
|
|
|
39
|
-
### DealTable
|
|
39
|
+
#### DealTable
|
|
40
40
|
|
|
41
41
|
|----------------------------------------
|
|
42
42
|
|
|
@@ -66,7 +66,7 @@
|
|
|
66
66
|
|
|
67
67
|
|
|
68
68
|
|
|
69
|
-
### 求める結果(sum = price * amount)
|
|
69
|
+
#### 求める結果(sum = price * amount)
|
|
70
70
|
|
|
71
71
|
* 各商品、最新の2件の価格を一つにして、取得したい
|
|
72
72
|
|
|
@@ -91,7 +91,3 @@
|
|
|
91
91
|
|0003| 110 | 200 | *** |
|
|
92
92
|
|
|
93
93
|
---------------------------------------------
|
|
94
|
-
|
|
95
|
-
|
|
96
|
-
|
|
97
|
-
```
|