回答編集履歴
3
推敲
test
CHANGED
@@ -16,7 +16,7 @@
|
|
16
16
|
|
17
17
|
) step1
|
18
18
|
|
19
|
-
WHERE 日時 >= '2018-03-01' AND 日時 < '2018-03-2
|
19
|
+
WHERE 日時 >= '2018-03-01' AND 日時 < '2018-03-21'
|
20
20
|
|
21
21
|
) step2
|
22
22
|
|
2
修正
test
CHANGED
@@ -6,7 +6,7 @@
|
|
6
6
|
|
7
7
|
from (
|
8
8
|
|
9
|
-
select *, lead(日時) over (partition by format(日時, 'yyyy/
|
9
|
+
select *, lead(日時) over (partition by format(日時, 'yyyy/MM/dd HH:mm') order by 日時) as 次秒
|
10
10
|
|
11
11
|
from (
|
12
12
|
|
1
推敲
test
CHANGED
@@ -6,7 +6,7 @@
|
|
6
6
|
|
7
7
|
from (
|
8
8
|
|
9
|
-
select *, lead(日時) over (partition by format(日時, 'yyyy/mm/dd HH:mm') order by 日時) as 次
|
9
|
+
select *, lead(日時) over (partition by format(日時, 'yyyy/mm/dd HH:mm') order by 日時) as 次秒
|
10
10
|
|
11
11
|
from (
|
12
12
|
|
@@ -20,6 +20,6 @@
|
|
20
20
|
|
21
21
|
) step2
|
22
22
|
|
23
|
-
where 次
|
23
|
+
where 次秒 is null
|
24
24
|
|
25
25
|
```
|