By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
99 rows affected
ID | A | LAST_VALUE(A)IGNORENULLSOVER(ORDERBYID) |
---|---|---|
1 | 1 | 1 |
2 | null | 1 |
3 | null | 1 |
4 | null | 1 |
5 | null | 1 |
6 | null | 1 |
7 | 7 | 7 |
8 | 8 | 8 |
9 | 9 | 9 |
10 | 10 | 10 |
11 | null | 10 |
12 | 12 | 12 |
13 | 13 | 13 |
14 | 14 | 14 |
15 | null | 14 |
16 | 16 | 16 |
17 | 17 | 17 |
18 | null | 17 |
19 | null | 17 |
20 | null | 17 |
21 | null | 17 |
22 | null | 17 |
23 | null | 17 |
24 | 24 | 24 |
25 | null | 24 |
26 | 26 | 26 |
27 | null | 26 |
28 | 28 | 28 |
29 | 29 | 29 |
30 | null | 29 |
31 | null | 29 |
32 | 32 | 32 |
33 | null | 32 |
34 | 34 | 34 |
35 | 35 | 35 |
36 | null | 35 |
37 | 37 | 37 |
38 | null | 37 |
39 | 39 | 39 |
40 | 40 | 40 |
41 | null | 40 |
42 | null | 40 |
43 | 43 | 43 |
44 | 44 | 44 |
45 | 45 | 45 |
46 | 46 | 46 |
47 | null | 46 |
48 | 48 | 48 |
49 | null | 48 |
50 | null | 48 |
51 | null | 48 |
52 | 52 | 52 |
53 | 53 | 53 |
54 | null | 53 |
55 | null | 53 |
56 | null | 53 |
57 | null | 53 |
58 | 58 | 58 |
59 | null | 58 |
60 | null | 58 |
61 | 61 | 61 |
62 | 62 | 62 |
63 | 63 | 63 |
64 | 64 | 64 |
65 | null | 64 |
66 | null | 64 |
67 | null | 64 |
68 | null | 64 |
69 | 69 | 69 |
70 | null | 69 |
71 | 71 | 71 |
72 | 72 | 72 |
73 | null | 72 |
74 | 74 | 74 |
75 | null | 74 |
76 | 76 | 76 |
77 | 77 | 77 |
78 | 78 | 78 |
79 | 79 | 79 |
80 | 80 | 80 |
81 | null | 80 |
82 | 82 | 82 |
83 | 83 | 83 |
84 | 84 | 84 |
85 | 85 | 85 |
86 | null | 85 |
87 | 87 | 87 |
88 | null | 87 |
89 | null | 87 |
90 | null | 87 |
91 | null | 87 |
92 | 92 | 92 |
93 | 93 | 93 |
94 | null | 93 |
95 | 95 | 95 |
96 | 96 | 96 |
97 | 97 | 97 |
98 | 98 | 98 |
99 | null | 98 |