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);上面是按每小時(shí)統(tǒng)計(jì)的，請問如何按每2小時(shí)統(tǒng)計(jì)呢？
添加回答
舉報(bào)
0/150
提交
取消