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