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

最新推荐文章于 2024-02-20 14:40:42 发布

原创最新推荐文章于 2024-02-20 14:40:42 发布 · 1.7k 阅读

4 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

6 篇文章

订阅专栏

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