回答編集履歴
2
推敲
answer
CHANGED
|
@@ -25,13 +25,17 @@
|
|
|
25
25
|
;
|
|
26
26
|
```
|
|
27
27
|
```SQL
|
|
28
|
+
select * from tbl
|
|
29
|
+
where code='0'
|
|
30
|
+
and date_time in (
|
|
28
|
-
select
|
|
31
|
+
select max(t1.date_time)
|
|
29
|
-
from
|
|
32
|
+
from tbl t1 inner join (
|
|
30
|
-
|
|
33
|
+
select date_time start_range, dateadd(mi,1, date_time) end_range
|
|
31
|
-
|
|
34
|
+
from tbl
|
|
32
|
-
|
|
35
|
+
where format(date_time,'ss')='00' and code='0'
|
|
33
|
-
|
|
36
|
+
) as t2
|
|
34
|
-
|
|
37
|
+
on t1.date_time>t2.start_range and t1.date_time<t2.end_range
|
|
35
|
-
where
|
|
38
|
+
where t1.code='0'
|
|
36
|
-
group by
|
|
39
|
+
group by t2.start_range, t2.end_range
|
|
40
|
+
)
|
|
37
41
|
```
|
1
推敲
answer
CHANGED
|
@@ -1,4 +1,4 @@
|
|
|
1
|
-
起点となるのは正分（
|
|
1
|
+
起点となるのは正分（ss=00)のcode='0'で、一分以内のcode='0'のもので最終
|
|
2
2
|
という条件として以下
|
|
3
3
|
|
|
4
4
|
```SQL
|