常用sql:每天统计等
常用sql:每天统计等每天统计
每天统计
select
year(CREATED_AT) as yearcount,
month(CREATED_AT) as monthcount,
day(CREATED_AT) daycount,
count(1) COUNT1
from 表名
GROUP BY yearcount,monthcount,daycount
ORDER BY COUNT1 de...
原创
2019-08-23 18:08:43 ·
544 阅读 ·
0 评论