在给定的日期范围内,我需要每天从上午9点到下午6点统计表中的记录数。示例输出应如下所示:
Date Count of users 01-11-2018 100 02-11-2018 88 03-11-2018 107 04-11-2018 113
bxfogqkk1#
SELECT `date`, Count(*) FROM table_name tn WHERE tn.date >= Timestampadd(hour, 9, Curdate()) AND tn.date <= Timestampadd(hour, 18, Curdate()) GROUP BY `date`
yxyvkwin2#
SELECT DATE(date), count(*) FROM table WHERE TIME(date) BETWEEN TIME('9:00:00') AND TIME('18:00:00') GROUP BY DATE(date)
2条答案
按热度按时间bxfogqkk1#
yxyvkwin2#