nian gz
2000 100
2001 200
2002 300
2003 400
第一种:select nian, (select sum(gz) from mp b where b.nian<= a.nian) gz from mp a group by nian
第二种:select b.id,sum(a.gz) from mp a,mp b where a.gz<=b.gz group by b.id
nian gz
2000 100
2001 300
2002 600
2003 1000