回答編集履歴
2
lag -> lead
test
CHANGED
|
@@ -13,7 +13,7 @@
|
|
|
13
13
|
bb as (
|
|
14
14
|
select
|
|
15
15
|
*,
|
|
16
|
-
la
|
|
16
|
+
lead(counter) over (order by time) as nextCounter
|
|
17
17
|
from aa
|
|
18
18
|
)
|
|
19
19
|
select * from bb
|
1
typo
test
CHANGED
|
@@ -25,7 +25,7 @@
|
|
|
25
25
|
```
|
|
26
26
|
|
|
27
27
|
|time|counter|nextcounter|
|
|
28
|
-
|----|-------|-----------|
|
|
28
|
+
|----|-------:|-----------:|
|
|
29
29
|
|2023-06-19 14:27:00.000|14553|61|
|
|
30
30
|
|2023-06-19 14:36:00.000|14958|9|
|
|
31
31
|
|2023-06-19 14:46:00.000|15458|37|
|