回答編集履歴
1
調整
test
CHANGED
|
@@ -70,7 +70,7 @@
|
|
|
70
70
|
|
|
71
71
|
select max(id) as id from tbl group by tran_grp
|
|
72
72
|
|
|
73
|
-
union select id from tbl where settle_grp is not null) as t2
|
|
73
|
+
union select id from tbl where settle_grp is not null) as t2 using(id)
|
|
74
74
|
|
|
75
75
|
where amount >= 0
|
|
76
76
|
|