月统计sql
select convert(varchar(7),表时间字段,120) ,sum(表数据字段) from group by convert(varchar(7),表时间字段,120);
主要实现在这里 group by convert(varchar(7),表时间字段,120)
group by 分组
convert(varchar(7),表时间字段,120) 表示时间月份 2012年 5月。通过这条语句他会把5月份数据全部获取
例:
select convert(varchar(7),YFF_SDJL.D_CZSJ,120) as d_da,sum(YFF_SDJL.N_GMJE) as total_gmje,
sum(YFF_SDJL.N_SSJE) as n_totalMoney,SUM(YFF_SDJL.N_GDCS) as total_gdcs,SUM(YFF_SDJL.N_KCFY1) as total_yz
from YFF_SDJL where YFF_SDJL.S_YXBZ = 'Y' group by convert(varchar(7),YFF_SDJL.D_CZSJ,120)
不清楚留言