SELECT
DATE_FORMAT(`created_at`, '%Y-%m-%d %H' ) as time,
COUNT( DISTINCT id) as count
FROM
mkt_invoice where `activity_id` =1566010856907014146
GROUP BY
time
ORDER BY
time
08-27
3254
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
SELECT
DATE_FORMAT(`created_at`, '%Y-%m-%d %H' ) as time,
COUNT( DISTINCT id) as count
FROM
mkt_invoice where `activity_id` =1566010856907014146
GROUP BY
time
ORDER BY
time