ORACLE 有取下一条分组记录的分析函数。
SELECT COL1,COL2, COL3 FROM
(SELECT COL1, COL2, LEAD(COL1) OVER(ORDER BY COL1) AS COL3 FROM TEST12)
WHERE COL2 > COL3
或者
SELECT A.COL1,A.COL2,
(SELECT COL1 FROM (SELECT COL1, ROWNUM NUM FROM TEST12 ORDER BY COL1) WHERE NUM = A.NUM + 1) AS COL3
FROM
(SELECT COL1, COL2, ROWNUM AS NUM FROM TEST12 ORDER BY COL1) A
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024