回答編集履歴
3
推敲
answer
CHANGED
|
@@ -7,7 +7,7 @@
|
|
|
7
7
|
SELECT *,DATEADD(S,[時間],'19700101 09:00:00') as 日時
|
|
8
8
|
FROM test_tbl
|
|
9
9
|
) step1
|
|
10
|
-
WHERE 日時 >= '2018-03-01' AND 日時 < '2018-03-
|
|
10
|
+
WHERE 日時 >= '2018-03-01' AND 日時 < '2018-03-21'
|
|
11
11
|
) step2
|
|
12
12
|
where 次秒 is null
|
|
13
13
|
```
|
2
修正
answer
CHANGED
|
@@ -2,7 +2,7 @@
|
|
|
2
2
|
```SQL
|
|
3
3
|
select *
|
|
4
4
|
from (
|
|
5
|
-
select *, lead(日時) over (partition by format(日時, 'yyyy/
|
|
5
|
+
select *, lead(日時) over (partition by format(日時, 'yyyy/MM/dd HH:mm') order by 日時) as 次秒
|
|
6
6
|
from (
|
|
7
7
|
SELECT *,DATEADD(S,[時間],'19700101 09:00:00') as 日時
|
|
8
8
|
FROM test_tbl
|
1
推敲
answer
CHANGED
|
@@ -2,12 +2,12 @@
|
|
|
2
2
|
```SQL
|
|
3
3
|
select *
|
|
4
4
|
from (
|
|
5
|
-
select *, lead(日時) over (partition by format(日時, 'yyyy/mm/dd HH:mm') order by 日時) as 次
|
|
5
|
+
select *, lead(日時) over (partition by format(日時, 'yyyy/mm/dd HH:mm') order by 日時) as 次秒
|
|
6
6
|
from (
|
|
7
7
|
SELECT *,DATEADD(S,[時間],'19700101 09:00:00') as 日時
|
|
8
8
|
FROM test_tbl
|
|
9
9
|
) step1
|
|
10
10
|
WHERE 日時 >= '2018-03-01' AND 日時 < '2018-03-20'
|
|
11
11
|
) step2
|
|
12
|
-
where 次
|
|
12
|
+
where 次秒 is null
|
|
13
13
|
```
|