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小时统计呢?
添加回答
举报
0/150
提交
取消