id count1 count2 count3 count4 date
1 50 80 30 68 2010-09-01
2 60 20 50 50 2010-09-02
3 40 30 25 20 2010-09-03
4 80 50 35 60 2010-09-04
上面这个是表,我想在查询的时候,把一段时间内的平均数也算出来,有没有办法实现啊.
select * from count where date between 2010-09-01 and 2010-09-03
这样能查出来2条记录,那么就算出他的平均值,效果就是这样
id count1 count2 count3 count4 date
1 50 80 30 68 2010-09-01
2 60 20 50 50 2010-09-02
55 50 40 59
直接用一条sql能否实现啊?
除了下面的方法还有别的没:
select count1, count2, count3, count4 from count where date between 2010-09-01 and 2010-09-03
unit
select avg(count1), avg(count2), avg(count3), avg(count4) from count where date between 2010-09-01 and 2010-09-03