select sum(sl) from b group by month(rq)

select  MIN(A.gxzlno) AS  gxzlno  ,    SUM(A.jine) AS JINE  ,min(a.riqi) as riqi

FROM (SELECT ewangong.gxzlno as gxzlno,      (ewangong.shuliang) as jine   , ewangong.endtime as riqi  FROM 

 ewangong   WHERE  1=1

 ${if(len(starttime)=0,""," and ewangong.endtime>='"+starttime+"'")}

 ${if(len(endtime)=0,""," and ewangong.endtime<='"+endtime+"'")}  

) A   group by  A.gxzlno ,a.riqi ORDER BY  a.riqi, A.gxzlno

这个语句你参考一下 ,能得到这样的效果， 什么人，每日日期，汇总数