select *,(select top 1 i from 你的表 where a=tem2.a and c=tem2.c and d=tem2.d and i>tem2.ii order by i) iii from (select *,(select top 1 i from 你的表 where a=tem.a and c=tem.c and d=tem.d and i>tem.i order by i) ii from (select a,c,d,sum(e) e,sum(f) f,min(i) i from 你的表 group by a,c,d) tem) tem2
insert 你的表 values('f3001006698','f3036001','2003-10-5', 112.3,0,200306)
insert 你的表 values('f3001006698','f3036001','2003-10-5', -112.3,0,200306)
insert 你的表 values('f3001006698','f3036001','2003-10-5', 112.3,0,200306)
insert 你的表 values('f3001006698','f3036001','2003-10-5',21,0,200307)
insert 你的表 values('f3001006698','f3036001','2003-10-5', -21,0,200307)
insert 你的表 values('f3001006698','f3036001','2003-10-5', 21,0,200307)
insert 你的表 values('f3001006698','f3036001','2003-10-5', 16.7,0,200308)
insert 你的表 values('f3001006698','f3036001','2003-10-5', -16.7,0,200308)
insert 你的表 values('f3001006698','f3036001','2003-10-5', 16.7,0,200308)
insert 你的表 values('f3100024334','f3027001','2003-10-6', 39.31,5.54,200307)
insert 你的表 values('f3100024334','f3027001','2003-10-6', 18,0.86,200308)
insert 你的表 values('f3100043641','f0000ds1','2003-10-2', 58.16,1.84,200308)
insert 你的表 values('f3100044679','f3029001','2003-10-8', 22.89,3.36,200307)
insert 你的表 values('f3100044679','f3029001','2003-10-8', 32.61,1.76,200308)
insert 你的表 values('f3506462712','f3001005','2003-10-1', 205.31,44.96,200306)
insert 你的表 values('f3506462712','f3001005','2003-10-1', 37.3,4.7,200307)
insert 你的表 values('f3506462712','f3001005','2003-10-1', 27,0.73,200308)
select *,(select top 1 i from 你的表 where a=tem2.a and c=tem2.c and d=tem2.d and i>tem2.ii order by i) iii from (select *,(select top 1 i from 你的表 where a=tem.a and c=tem.c and d=tem.d and i>tem.i order by i) ii from (select a,c,d,sum(e) e,sum(f) f,min(i) i from 你的表 group by a,c,d) tem) tem2go
drop table 你的表