首先你的表中需要有一个发布日期才能做这样的统计假设你的表名是tab,发布日期字段为createdate那么SQL如下select count(*), CONVERT(varchar(100), createdate, 23) from tab where CONVERT(varchar(100), createdate, 23) between CONVERT(varchar(100), dateadd(d,-7,getdate()), 23) and CONVERT(varchar(100), dateadd(d,-1,getdate()), 23) group by CONVERT(varchar(100), createdate,
|