sql月份累加统计查询
累计统计
可以根据id字段大小
select mm.id,mm.name,sum(m.age) from
mshi mm,mshi m
where m.id<=mm.id
group by mm.id
或者:
select mm.id,mm.name,sum(m.age) from mshi m inner join
mshi mm on m.id<=mm.id
group by mm.id
sql月份累加统计查询
sql月份累加统计查询