15:53:52 SQL> select * from tcd;AAA BBB
---------- -------------------
a 2003-06-25 12:00:00
a 2003-06-25 12:05:00
a 2003-06-25 12:10:00
a 2003-06-25 12:15:00
a 2003-06-25 12:30:00
a 2003-06-25 12:35:00
a 2003-06-25 12:40:00
a 2003-06-25 12:45:00
a 2003-06-25 12:55:00已选择9行。实际:60
15:54:05 SQL> select sj1,sj2 from
15:54:24 2 ( select t1.bbb sj1,t2.bbb sj2,t2.bbb-t1.bbb sjc from
15:54:27 3 (select rownum id1,bbb from tcd) t1,
15:54:27 4 (select rownum-1 id2,bbb from tcd) t2
15:54:27 5 where t1.id1=t2.id2(+)
15:54:27 6 ) where sjc>5/(24*60);SJ1 SJ2
------------------- -------------------
2003-06-25 12:15:00 2003-06-25 12:30:00
2003-06-25 12:45:00 2003-06-25 12:55:00实际:40
15:54:27 SQL> 自己找着改改吧
---------- -------------------
a 2003-06-25 12:00:00
a 2003-06-25 12:05:00
a 2003-06-25 12:10:00
a 2003-06-25 12:15:00
a 2003-06-25 12:30:00
a 2003-06-25 12:35:00
a 2003-06-25 12:40:00
a 2003-06-25 12:45:00
a 2003-06-25 12:55:00已选择9行。实际:60
15:54:05 SQL> select sj1,sj2 from
15:54:24 2 ( select t1.bbb sj1,t2.bbb sj2,t2.bbb-t1.bbb sjc from
15:54:27 3 (select rownum id1,bbb from tcd) t1,
15:54:27 4 (select rownum-1 id2,bbb from tcd) t2
15:54:27 5 where t1.id1=t2.id2(+)
15:54:27 6 ) where sjc>5/(24*60);SJ1 SJ2
------------------- -------------------
2003-06-25 12:15:00 2003-06-25 12:30:00
2003-06-25 12:45:00 2003-06-25 12:55:00实际:40
15:54:27 SQL> 自己找着改改吧
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货