質問編集履歴
4
Ｓ
test
CHANGED
|
@@ -1 +1 @@
|
|
|
1
|
-
SQLサマリーの求め方
|
|
1
|
+
ＳSQLサマリーの求め方
|
test
CHANGED
|
@@ -112,7 +112,7 @@
|
|
|
112
112
|
|
|
113
113
|
```SQL
|
|
114
114
|
|
|
115
|
-
select t1.cd,t1.lot,
|
|
115
|
+
select t1.cd,t1.lot,SUBSTR(売上日,1,7)||'/01',sum(t2.売上額) from 売上ロット t1
|
|
116
116
|
|
|
117
117
|
left join 売上トラン t2
|
|
118
118
|
|
|
@@ -122,6 +122,6 @@
|
|
|
122
122
|
|
|
123
123
|
and 売上日 < '2019/02/01'
|
|
124
124
|
|
|
125
|
-
group by t1.cd,t1.lot,
|
|
125
|
+
group by t1.cd,t1.lot,SUBSTR(売上日,1,7)||'/01'
|
|
126
126
|
|
|
127
127
|
```
|
3
T
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -1,3 +1,5 @@
|
|
|
1
|
+
```CREATE TABLE
|
|
2
|
+
|
|
1
3
|
create table 売上ロット
|
|
2
4
|
|
|
3
5
|
(
|
|
@@ -26,6 +28,10 @@
|
|
|
26
28
|
|
|
27
29
|
;
|
|
28
30
|
|
|
31
|
+
```
|
|
32
|
+
|
|
33
|
+
```INSERT
|
|
34
|
+
|
|
29
35
|
insert into 売上ロット values('123','D1','2019/01/01');
|
|
30
36
|
|
|
31
37
|
insert into 売上ロット values('123','D2','2019/02/01');
|
|
@@ -39,6 +45,8 @@
|
|
|
39
45
|
insert into 売上トラン values('123',120,'2019/03/01');
|
|
40
46
|
|
|
41
47
|
commit;
|
|
48
|
+
|
|
49
|
+
```
|
|
42
50
|
|
|
43
51
|
|
|
44
52
|
|
2
追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -24,7 +24,21 @@
|
|
|
24
24
|
|
|
25
25
|
)
|
|
26
26
|
|
|
27
|
+
;
|
|
27
28
|
|
|
29
|
+
insert into 売上ロット values('123','D1','2019/01/01');
|
|
30
|
+
|
|
31
|
+
insert into 売上ロット values('123','D2','2019/02/01');
|
|
32
|
+
|
|
33
|
+
insert into 売上ロット values('123','D3','2019/03/01');
|
|
34
|
+
|
|
35
|
+
insert into 売上トラン values('123',30,'2019/01/01');
|
|
36
|
+
|
|
37
|
+
insert into 売上トラン values('123',10,'2019/01/06');
|
|
38
|
+
|
|
39
|
+
insert into 売上トラン values('123',120,'2019/03/01');
|
|
40
|
+
|
|
41
|
+
commit;
|
|
28
42
|
|
|
29
43
|
|
|
30
44
|
|
1
追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -1,6 +1,36 @@
|
|
|
1
|
+
create table 売上ロット
|
|
2
|
+
|
|
3
|
+
(
|
|
4
|
+
|
|
5
|
+
cd varchar2(10)
|
|
6
|
+
|
|
7
|
+
,LOT varchar2(10)
|
|
8
|
+
|
|
9
|
+
,最古売上月 varchar2(10)
|
|
10
|
+
|
|
11
|
+
)
|
|
12
|
+
|
|
13
|
+
;
|
|
14
|
+
|
|
15
|
+
create table 売上トラン
|
|
16
|
+
|
|
17
|
+
(
|
|
18
|
+
|
|
19
|
+
cd varchar2(10)
|
|
20
|
+
|
|
21
|
+
,売上額 number
|
|
22
|
+
|
|
23
|
+
,売上日 varchar2(10)
|
|
24
|
+
|
|
25
|
+
)
|
|
26
|
+
|
|
27
|
+
|
|
28
|
+
|
|
29
|
+
|
|
30
|
+
|
|
1
31
|
売上ロット
|
|
2
32
|
|
|
3
|
-
CD
|
|
33
|
+
CD LOT 最古売上月
|
|
4
34
|
|
|
5
35
|
-------+-------+-------
|
|
6
36
|
|