展开全部
没懂你的整点是什么意思,先写一下
创建表插入数据:create table test
(name varchar2(10),
value int,
time date);
insert into test values ('张三',150,to_date('2017-09-11 12:01:01','yyyy-mm-dd hh24:mi:ss'));
insert into test values ('李四',280,to_date('2017-09-11 12:01:01','yyyy-mm-dd hh24:mi:ss'));
insert into test values ('老王62616964757a686964616fe78988e69d8331333363393665',177,to_date('2017-09-11 12:01:01','yyyy-mm-dd hh24:mi:ss'));
insert into test values ('张三',170,to_date('2017-09-11 13:01:01','yyyy-mm-dd hh24:mi:ss'));
insert into test values ('李四',320,to_date('2017-09-11 13:01:01','yyyy-mm-dd hh24:mi:ss'));
insert into test values ('老王',277,to_date('2017-09-11 13:01:01','yyyy-mm-dd hh24:mi:ss'));
commit;
执行:with t as
(select name,value,row_number() over (partition by name order by time) rn from test)
select t1.name,t1.value,t2.value,t2.value-t1.value from t t1,t t2 where t1.rn(+)=t2.rn-1 and t1.name=t2.name
结果:
注意:如果答案被推荐没法追答,请私信联系。