问题:

比如记录2007-02-01有3条,2007-02-02有5条,2007-02-03有4条

我要取2007-02-01对应3条的和,2007-02-02对应8条的和,2007-02-03对应12条的和
就是取该记录与该记录前面所有记录的字段值的和

结果如下:
 2007-02-01      3条        300
 2007-02-02      5条        500
 2007-02-03      12条       1200

测试表: test

 today                  fee

 2007-02-01             100

 2007-02-01             100
 2007-02-02            100

 2007-02-02            100
 2007-02-03             100

 2007-02-03             100

sql:

select a.today, sum(b.newfee) from (select distinct(today) from test) a,

(select today,sum(fee) as newfee from TEST   group by today)

   b where  b.today<=a.today group by a.today order by a.today desc 

发表于 @ 2007年02月05日 17:31:00|评论(loading...)|编辑