时间间隔分组

bigdata-sb bigdata-sb 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区

-- Create table
create table TEST
(
msg_id VARCHAR2(200),
send_time DATE
)


insert into test (MSG_ID, SEND_TIME)
values ('aaa', to_date('15-06-2018 09:00:00', 'dd-mm-yyyy hh24:mi:ss'));

insert into test (MSG_ID, SEND_TIME)
values ('bbb', to_date('15-06-2018 09:01:00', 'dd-mm-yyyy hh24:mi:ss'));

insert into test (MSG_ID, SEND_TIME)
values ('ccc', to_date('15-06-2018 09:02:00', 'dd-mm-yyyy hh24:mi:ss'));

insert into test (MSG_ID, SEND_TIME)
values ('ddd', to_date('15-06-2018 09:05:00', 'dd-mm-yyyy hh24:mi:ss'));

insert into test (MSG_ID, SEND_TIME)
values ('eee', to_date('15-06-2018 09:08:00', 'dd-mm-yyyy hh24:mi:ss'));

insert into test (MSG_ID, SEND_TIME)
values ('fff', to_date('15-06-2018 09:09:00', 'dd-mm-yyyy hh24:mi:ss'));

insert into test (MSG_ID, SEND_TIME)
values ('ggg', to_date('15-06-2018 09:13:00', 'dd-mm-yyyy hh24:mi:ss'));

insert into test (MSG_ID, SEND_TIME)
values ('hhh', to_date('15-06-2018 10:00:00', 'dd-mm-yyyy hh24:mi:ss'));

insert into test (MSG_ID, SEND_TIME)
values ('iii', to_date('15-06-2018 10:03:00', 'dd-mm-yyyy hh24:mi:ss'));

insert into test (MSG_ID, SEND_TIME)
values ('jjj', to_date('15-06-2018 10:20:00', 'dd-mm-yyyy hh24:mi:ss'));





...全文

相关推荐

评论 3
收藏 已收藏
分享
返回顶部
bigdata-sb
Hadoop生态社区 20,842 成员 4,695 内容