SELECT
DATE( date ) created_at,
count( id ) count
FROM
(# 构造当前日期之前31天的日期表
SELECT @cdate := date_add(@cdate, INTERVAL - 1 DAY) date
FROM (SELECT @cdate := date_add(CURRENT_DATE, INTERVAL 1 DAY) FROM account LIMIT 999) a
) t_date
LEFT JOIN account a ON DATE( a.created_at) = t_date.date
WHERE
to_days( now( ) ) - to_days( date ) <= 60
GROUP BY
to_days( date )
ORDER BY
to_days( date ) ASC
sql查询多少天内的数据集合
最新推荐文章于 2022-05-12 10:32:59 发布