主要用到DATEDIFF得到相同的周,再按周集合
select DATEDIFF(week,RiQi,getdate()),avg(B01) from Price WHERE PinZhong=93 group by DATEDIFF(week,RiQi,getdate()) order by DATEDIFF(week,RiQi,getdate())
作者:敖士伟 ikmb@163.com
主要用到DATEDIFF得到相同的周,再按周集合
select DATEDIFF(week,RiQi,getdate()),avg(B01) from Price WHERE PinZhong=93 group by DATEDIFF(week,RiQi,getdate()) order by DATEDIFF(week,RiQi,getdate())
作者:敖士伟 ikmb@163.com