The query
SELECT I, J,
SUM(J) OVER (W2) AS ERROR_SUM, -- looks like no partition
SUM(J) OVER (W1 ORDER BY J) AS CORRECT1,
SUM(J) OVER (PARTITION BY I ORDER BY J) AS CORRECT2,
SUM(J) OVER (ORDER BY J) AS LIKE_ERROR_SUM
FROM T
WINDOW
W1 AS (PARTITION BY I),
W2 AS (W1 ORDER BY J)returns
| I |
J |
ERROR_SUM |
CORRECT1 |
CORRECT2 |
LIKEERRORSUM |
| 1 |
10 |
10 |
10 |
10 |
10 |
| 2 |
20 |
30 |
20 |
20 |
30 |
| 3 |
30 |
60 |
30 |
30 |
60 |
| 4 |
40 |
100 |
40 |
40 |
100 |
| 5 |
50 |
150 |
50 |
50 |
150 |
It looks as if PARTITION BY of W1 is lost in W2.
The query
returns
It looks as if
PARTITION BYof W1 is lost in W2.