建一个视图看看:
select a.CurrALL-b.CurrALL Call_All,
a.CurrTime-B.CurrTime BetweenTime,a.*
from (select rownum row,a.* from you_table order by CurrTime) a,(select rownum row,a.* from you_table order by CurrTime) b
where a.row=b.row-1
然后在视图上查询就行了
select a.CurrALL-b.CurrALL Call_All,
a.CurrTime-B.CurrTime BetweenTime,a.*
from (select rownum row,a.* from you_table order by CurrTime) a,(select rownum row,a.* from you_table order by CurrTime) b
where a.row=b.row-1
然后在视图上查询就行了
解决方案 »
- j求一个检查java程序死锁工具
- 乱码解决办法
- 急。。急。。。。JAVA 缓存区读写指针??
- apache 二级域名 url重写 。
- netbeans开发java/jsp,不是用netbeans的请不要进入,否则kill
- java远程下载文件(急)
- eclipse+tomcat+lomboz 如何写jsp
- 刷新页面的问题
- 连接数据库提示我"DriverManager" is either a misplaced package name or a non-existent entity.
- 是不是在win2000下构建jsp服务器得安装apache+tomcat+jdk,同时以上软件哪里有下载
- 请教:jsp 中变量之间的类型转换问题?如String,long,int等
- 关于网站的奇怪问题,大家来看看
建一个视图看看:
select a.CurrALL-b.CurrALL Call_All,
a.CurrTime-B.CurrTime BetweenTime,a.*
from (select rownum row,a.* from you_table a order by CurrTime) a,(select rownum row,a.* from you_table a order by CurrTime ) b
where a.row=b.row-1
然后在视图上查询就行了