作者官方网站:http://www.wxl568.cn
统计全年每天上班在9:00-9:30的数据
select
count(1),
t.clock_time_b
from
(
select
DATE_FORMAT(clock_time, 'HH:mm') as clock_time_a,
DATE_FORMAT(clock_time, 'yyyy-MM-dd') as clock_time_b,
clock_time
from
ods_hrssgps.tt_clock_log
where
inc_day >= '20190101'
and inc_day <= '20191231'
) t
where
t.clock_time_a >= '09:00'
and t.clock_time_a <= '09:30'
group by
t.clock_time_b;