17,090
社区成员
发帖
与我相关
我的任务
分享
如果第一行去掉的话,则可以改下sql如下:
SELECT COL
FROM (SELECT A - LAG(A, 1, 0) OVER(ORDER BY ROWNUM) COL, ROWNUM RN FROM T)
WHERE RN > 1;
--运行结果
COL
1 11
2 6
3 13
4 20
5 12
6 28
CREATE TABLE T(A NUMBER);
INSERT INTO T VALUES(9);
INSERT INTO T VALUES(20);
INSERT INTO T VALUES(26);
INSERT INTO T VALUES(39);
INSERT INTO T VALUES(59);
INSERT INTO T VALUES(71);
INSERT INTO T VALUES(99);
SELECT A-LAG(A,1,0) OVER(ORDER BY ROWNUM) COL FROM T;
-- 运行结果
COL
1 9
2 11
3 6
4 13
5 20
6 12
7 28