sql语句根据year,mouth,day分组查询统计数目
sql语句查询的格式如下year(a.time),mouth(a.time),day(a.time)将日期分隔为年月日在一定的条件下分组查询数据并统计数目1、根据年份统计group by year(a.time)2、根据月份统计group by year(a.time),mouth(a.time)3、根据某一天的日志分组查询group by year(a.time),mouth(a...
原创
2020-01-06 14:51:57 ·
1220 阅读 ·
1 评论