回答編集履歴
2
推敲
test
CHANGED
|
@@ -52,22 +52,30 @@
|
|
|
52
52
|
|
|
53
53
|
```SQL
|
|
54
54
|
|
|
55
|
-
select m
|
|
55
|
+
select * from tbl
|
|
56
56
|
|
|
57
|
-
|
|
57
|
+
where code='0'
|
|
58
58
|
|
|
59
|
-
|
|
59
|
+
and date_time in (
|
|
60
60
|
|
|
61
|
-
|
|
61
|
+
select max(t1.date_time)
|
|
62
62
|
|
|
63
|
-
|
|
63
|
+
from tbl t1 inner join (
|
|
64
64
|
|
|
65
|
-
|
|
65
|
+
select date_time start_range, dateadd(mi,1, date_time) end_range
|
|
66
66
|
|
|
67
|
-
|
|
67
|
+
from tbl
|
|
68
68
|
|
|
69
|
-
where
|
|
69
|
+
where format(date_time,'ss')='00' and code='0'
|
|
70
70
|
|
|
71
|
+
) as t2
|
|
72
|
+
|
|
73
|
+
on t1.date_time>t2.start_range and t1.date_time<t2.end_range
|
|
74
|
+
|
|
75
|
+
where t1.code='0'
|
|
76
|
+
|
|
71
|
-
group by
|
|
77
|
+
group by t2.start_range, t2.end_range
|
|
78
|
+
|
|
79
|
+
)
|
|
72
80
|
|
|
73
81
|
```
|
1
推敲
test
CHANGED
|
@@ -1,4 +1,4 @@
|
|
|
1
|
-
起点となるのは正分（
|
|
1
|
+
起点となるのは正分（ss=00)のcode='0'で、一分以内のcode='0'のもので最終
|
|
2
2
|
|
|
3
3
|
という条件として以下
|
|
4
4
|
|