...
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT a, SUM(b) OVER w FROM T; WINDOW w AS (PARTITION BY c ORDER BY d ROWS UNBOUNDED PRECEDING); |
LEAD using default 1 row lead and not specifying default value
...
...
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT a, SUM(b) OVER w FROM T; WINDOW w AS (PARTITION BY c ORDER BY d ROWS UNBOUNDED PRECEDING); |
...