34,590
社区成员
发帖
与我相关
我的任务
分享
declare @begintime datetime
declare @endtime datetime
set @begintime = '2010-11-05'
set @endtime = '2011-05-20'
select convert(varchar(7),时间,120),count(*) from aa
where 时间 between @begintime and @endtime
group by convert(varchar(7),时间,120)
select convert(varchar(7),时间,120),count(*) from aa
where 时间 between '2011-01-05' and '2011-05-20'
group by convert(varchar(7),时间,120)