表 CIM_CUSTOMER_ORDER, "ID_" VARCHAR2(32),"ACCEPT_TIME" VARCHAR2(24)
insert into CIM_CUSTOMER_ORDER values ('1','2017-02-17 10:03:33')
insert into CIM_CUSTOMER_ORDER values ('2','2017-02-17 10:13:33')
insert into CIM_CUSTOMER_ORDER values ('3','2017-02-17 10:23:33')
insert into CIM_CUSTOMER_ORDER values ('4','2017-02-17 10:33:33')
insert into CIM_CUSTOMER_ORDER values ('5','2017-02-17 10:43:33')
想统计出 2017-02-17 10:00:00到2017-02-17 10:45:33这段时间内,每隔五分钟的数据量
结果如:
2017-02-17 10:05:00 1
2017-02-17 10:10:00 1
2017-02-17 10:15:00 2
2017-02-17 10:20:00 2
2017-02-17 10:25:00 3
2017-02-17 10:30:00 3
2017-02-17 10:35:00 4
..........