LAG Function (Window) HANA行偏移函数
CREATE ROW TABLE T (class CHAR(10), val INT, offset INT);
INSERT INTO T VALUES('A', 1, 1);
INSERT INTO T VALUES('A', 3, 3);
INSERT INTO T VALUES('A', 5, null);
INSERT INTO T VALUES('A', 5, 2);
INSERT INTO T VALUES('A', 10, 0);
INSERT INTO T VALUES('B', 1, 3);
INSERT INTO T VALUES('B', 1, 1);
INSERT INTO T VALUES('B', 7, 1);
SELECT class,
val,
offset,
LEAD(val) OVER (PARTITION BY class ORDER BY val) AS lead,
LEAD(val,offset,-val) OVER (PARTITION BY class ORDER BY val) AS lead2,
LAG(val) OVER (PARTITION BY class ORDER BY val) AS lag,
LAG(val,offset,-val) OVER (PARTITION BY class ORDER BY val) AS lag2
FROM T;
post SAP-Garson
原文链接:https://blog.csdn.net/wangbanmin/article/details/122389964文章来自于网络,如果侵犯了您的权益,请联系站长删除!