mysql中按照季度、月份等分组
mysql中关于分组的使用select DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tc_case group by weeks; select DATE_FORMAT(create_time,'%Y%m%d') days,count(caseid) count from tc_case group by days
原创
2017-08-21 15:06:12 ·
32403 阅读 ·
3 评论