sql 求期初及累计数

1029 6000601 3000301 1 NULL 111.00
1029 6000605 3000301 2 111.00 331.00
1029 6000606 3000301 3 331.00 661.00
1029 6000607 3000301 4 661.00 1101.00

 select FID, MID, GID,GroupNo, 
 (select sum(numsum) from v_tbArtsDayBill b  where b.GroupNo < a.GroupNo and  b.GID=a.GID and  b.FID=a.FID) as qc ,
  (select sum(numsum) from v_tbArtsDayBill b  where b.GroupNo <= a.GroupNo and  b.GID=a.GID and  b.FID=a.FID) as qm
  from v_tbArtsDayBill a group by FID, MID, GID,GroupNo
  HAVING  GID='3000301' and fid='1029'