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
提交
取消