lag:
返回数据列前后的的记录
CREATE TABLE T(ID INTEGER);
INSERT INTO T VALUES(1);
INSERT INTO T VALUES(2);
INSERT INTO T VALUES(3);
INSERT INTO T VALUES(4);
INSERT INTO T VALUES(5);
SELECT ID,LAG(ID) OVER(ORDER BY ID)
FROM T
ID PRE
1
2 1
3 2
4 3
5 4
lag:
返回数据列前后的的记录
CREATE TABLE T(ID INTEGER);
INSERT INTO T VALUES(1);
INSERT INTO T VALUES(2);
INSERT INTO T VALUES(3);
INSERT INTO T VALUES(4);
INSERT INTO T VALUES(5);
SELECT ID,LAG(ID) OVER(ORDER BY ID)
FROM T
ID PRE
1
2 1
3 2
4 3
5 4