按月、周、日查询统计数据量的sql语句

1、按日查询

SELECT   CONVERT(varchar(10), AddTime, 120) AS Day, COUNT(Id) AS 数量
FROM      tb_AdvRecord
GROUP BY CONVERT(varchar(10), AddTime, 120)
ORDER BY Day DESC

2、按周查询 

SELECT   DATEPART(week, AddTime) AS Week, COUNT(Id) AS 数量
FROM      tb_AdvRecord
GROUP BY DATEPART(week, AddTime)
ORDER BY Week DESC

3、按月查询 

SELECT   CONVERT(varchar(7), AddTime, 120) AS Month, COUNT(Id) AS 数量
FROM      tb_AdvRecord
GROUP BY CONVERT(varchar(7), AddTime, 120)
ORDER BY Month DESC