日期:2014-05-17 浏览次数:20588 次
where group avg
declare @state datetime,@end datetime set @state ='2013-03-04' set @end ='2013-04-01' select avg(zj)avgzj from [表名] where [jcrq] between @state and @end group by [jcrq]