SQL查询问题,怎么解决,谢谢!

[admi_zb]

date_e=request("date_e")
'date_e是一个日期假定为2005-01-01
date_r=request("date_r")
'date_r也是一个日期假定为2005-12-20 当然date_r一定会比date_e大,
表名为wawfi
字段名:date price
date price
2004-10-11 12
2005-01-01 14
2005-01-01 18
2005-04-05 24
2005-04-05 40
2005-06-07 80
2005-07-09 100
2005-09-11 50
2005-09-11 60
2005-12-13 50
我现在是要通过一个什么样的办法得到如下要结果
取从2005-01-01到2005-12-20这个时间段数据,但取出来的那一组数据里的日期不能有重复的.
那行重复的怎么办呢,例,2005-01-01这天的price有两个值,就是想通过运算取一个平均值,
让
2005-01-01 14
2005-01-01 18
变成
2005-01-01 16
取出的一组数据为
2005-01-01 16
2005-04-05 32
2005-06-07 80
2005-07-09 100
2005-09-11 55
2005-12-13 50

下面就是通过什么取得这组数据有5条
把16.32.80.10.55.50变成一个数组的值price_r(?????)
提问完成,,,各位大哥谢谢你们了!帮帮小弟.

[admi_zb]

select [date],avg(price) from wawfi where [date]>'2005-1-1' and [date]<'2005-12-12' group by [date] order by [date]

如果是access就将单引号改为#
取的数据只有date列的.是不是啊????????
dim U
for U=1 to Rec1
price_r=rs1("date")
rs1.movenext
response.write price_r
Next
这个样子不会出错
显示为
2005-01-01
2005-04-05
2005-06-07
2005-07-09
2005-09-11
2005-12-13
dim U
for U=1 to Rec1
price_r=rs1("price")
rs1.movenext
response.write price_r
Next
这样就出错.是什么问题
我希望显示为
16
32
80
100
55
50

[admi_zb]

改成这样
select [date],avg(price) as price from wawfi where [date]>'2005-1-1' and [date]<'2005-12-12' group by [date] order by [date]
就直接出错了什么都不能显示啊,大哥,

[admi_zb]

我改成这样
select [date],avg(price) as price1 from wawfi where [date]>'2005-1-1' and [date]<'2005-12-12' group by [date] order by [date]
就行了,呵呵,,
as price1

[admi_zb]

顶上去谢谢了,

[baiyunfei]

select [date],avg(price) from wawfi where [date]>'2005-1-1' and [date]<'2005-12-12' group by [date] order by [date]

如果是access就将单引号改为#

[hbhbhbhbhb1021]

sqlstr="select average(price) from [table] where date between '"& date_e & "' and '" & date_r & "' group by date"

[lstup]

合并数据可以。合并后你还要求合，这个就不好搞了

[spirit729]

select [date],avg(price) from wawfi where [date]>'2005-1-1' and [date]<'2005-12-12' group by [date] order by [date]

如果是access就将单引号改为#

[admi_zb]

select [date],avg(price) from wawfi where [date]>'2005-1-1' and [date]<'2005-12-12' group by [date] order by [date]

如果是access就将单引号改为#
取的数据只有date列的.是不是啊????????
dim U
for U=1 to Rec1
price_r=rs1("date")
rs1.movenext
response.write price_r
Next
这个样子不会出错
dim U
for U=1 to Rec1
price_r=rs1("price")
rs1.movenext
response.write price_r
Next
这样就出错.是什么问题啊,

[baiyunfei]

price 不是一个数据域了，当然出错啊。你可以这样：

select [date],avg(price) as price from wawfi where [date]>'2005-1-1' and [date]<'2005-12-12' group by [date] order by [date]
就不会出错了