SELECT HOUR(APPLY_TIME) as Hour,count(*) as Count FROM sesc_social_security WHERE APPLY_TIME like '2018-01-23%' GROUP BY HOUR(APPLY_TIME) ORDER BY Hour(APPLY_TIME);
上面是按每小时统计的,请问如何按每2小时统计呢?
相关分类