回答編集履歴
4
修正
test
CHANGED
|
@@ -44,7 +44,7 @@
|
|
|
44
44
|
|
|
45
45
|
FROM ZZZ t1 inner join (
|
|
46
46
|
|
|
47
|
-
select
|
|
47
|
+
select SUM(Qty) SUM_QTY, SUM(Tax) SUM_TAX, Min(ID) as Min_ID
|
|
48
48
|
|
|
49
49
|
FROM ZZZ
|
|
50
50
|
|
3
修正
test
CHANGED
|
@@ -52,6 +52,6 @@
|
|
|
52
52
|
|
|
53
53
|
) t2
|
|
54
54
|
|
|
55
|
-
on t1.
|
|
55
|
+
on t1.ID=T2.Min_ID
|
|
56
56
|
|
|
57
57
|
```
|
2
推敲
test
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
```SQL
|
|
8
8
|
|
|
9
|
-
SELECT
|
|
9
|
+
SELECT ID, t1.Line1, t1.Line2, Line3, Line4, Product
|
|
10
10
|
|
|
11
11
|
, t2.SUM_Qty as Qty, t2.SUM_Tax as Tax
|
|
12
12
|
|
|
@@ -36,7 +36,7 @@
|
|
|
36
36
|
|
|
37
37
|
```SQL
|
|
38
38
|
|
|
39
|
-
SELECT
|
|
39
|
+
SELECT ID, t1.Line1, t1.Line2, Line3, Line4, Product
|
|
40
40
|
|
|
41
41
|
, t2.SUM_Qty as Qty, t2.SUM_Tax as Tax
|
|
42
42
|
|
1
追記
test
CHANGED
|
@@ -31,3 +31,27 @@
|
|
|
31
31
|
)
|
|
32
32
|
|
|
33
33
|
```
|
|
34
|
+
|
|
35
|
+
他の回答をみて追記（上記より高速だと思います）
|
|
36
|
+
|
|
37
|
+
```SQL
|
|
38
|
+
|
|
39
|
+
SELECT t1.ID, t1.Line1, t1.Line2, Line3, Line4, Product
|
|
40
|
+
|
|
41
|
+
, t2.SUM_Qty as Qty, t2.SUM_Tax as Tax
|
|
42
|
+
|
|
43
|
+
, Date, Bikou1, Bikou2
|
|
44
|
+
|
|
45
|
+
FROM ZZZ t1 inner join (
|
|
46
|
+
|
|
47
|
+
select Line1, Line2, SUM(Qty) SUM_QTY, SUM(Tax) SUM_TAX, Min(ID) as Min_ID
|
|
48
|
+
|
|
49
|
+
FROM ZZZ
|
|
50
|
+
|
|
51
|
+
group by Line1, Line2
|
|
52
|
+
|
|
53
|
+
) t2
|
|
54
|
+
|
|
55
|
+
on t1.Line1=t2.Line1 and t1.Line2=t2.Line2 and t1.ID=T2.Min_ID
|
|
56
|
+
|
|
57
|
+
```
|