17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT A.seq,A.decisionid,A.instid,A.modelid,A.nodeid,A.optrid,A.opttime AS opttime,
A.result,A.remark,B.username,C.nodename,D.orgname,E.remark AS decisionremark
FROM tb_bpm_instancenode A LEFT JOIN tb_bpm_decision E
ON E.decisionid=A.decisionid AND E.modelid=A.modelid AND E.nodeid=A.nodeid,
tb_user B,tb_bpm_node C,tb_organization D
WHERE A.optrid=B.userid AND C.nodeid=A.nodeid AND D.orgcode=B.orgcode
AND A.instid='3BN10120000000030'
ORDER BY A.opttime,nodeid ;
WITH tab AS(
SELECT ROWNUM nodeid FROM dual CONNECT BY ROWNUM<=4
)
SELECT nodeid,nodeid+lead(nodeid,1)over(ORDER BY nodeid) num FROM tab
NODEID NUM
-----------------
1 3
2 5
3 7
4 9
5
WITH tab AS(
SELECT ROWNUM nodeid FROM dual CONNECT BY ROWNUM<=4
)
SELECT nodeid,nodeid+lead(nodeid,1,0)over(ORDER BY nodeid) num FROM tab
NODEID NUM
-----------------
1 3
2 5
3 7
4 9
5 5
--类似这样?
scott@YPCOST> select ename,sal,lagsal+sal from (
2 select ename,sal,lag(sal) over(order by sal) lagsal from emp);
ENAME SAL LAGSAL+SAL
---------- ---------- ----------
SMITH 800
JAMES 950 1750
ADAMS 1100 2050
WARD 1250 2350
MARTIN 1250 2500
MILLER 1430 2680
TURNER 1500 2930
ALLEN 1600 3100
CLARK 2450 4050
BLAKE 2850 5300
JONES 2975 5825
SCOTT 3000 5975
FORD 3000 6000
KING 5000 8000
已选择14行。