MySql按周，按月，按日分组统计数据
·
- select DATE_FORMAT(date,'%Y%u') weeks,count(id) count from table group by weeks;
- select DATE_FORMAT(date,'%Y%m%d') days,count(id) count from table group by days;
- select DATE_FORMAT(date,'%Y%m') months,count(id) count from table group by months;
图解SQL的inner join、left join、right join、full outer join、union、union all的区别
加入社区！打开量化的大门，首批课程上线啦！
更多推荐
0
0- 0
已为社区贡献1条内容
所有评论(0)