回答編集履歴
4
タイポ
answer
CHANGED
|
@@ -26,8 +26,6 @@
|
|
|
26
26
|
|
|
27
27
|
上記の結果に対して、staff_id , grp でGROUP BY して集計関数を実行すれば良いでしょう
|
|
28
28
|
|
|
29
|
-
。
|
|
30
|
-
|
|
31
29
|
```SQL
|
|
32
30
|
SELECT
|
|
33
31
|
staff_id
|
3
タイポ
answer
CHANGED
|
@@ -35,7 +35,7 @@
|
|
|
35
35
|
, COUNT(*) AS count
|
|
36
36
|
FROM (上記のSELECT文) AS T2
|
|
37
37
|
GROUP BY
|
|
38
|
-
|
|
38
|
+
staff_id
|
|
39
39
|
, grp
|
|
40
40
|
```
|
|
41
41
|
|
2
体裁
answer
CHANGED
|
@@ -11,7 +11,7 @@
|
|
|
11
11
|
|
|
12
12
|
を実行すると
|
|
13
13
|
|
|
14
|
-
| staff_id | datetime | status | grp | @old
|
|
14
|
+
| staff_id | datetime | status | grp | @old |
|
|
15
15
|
| :------- | :------------------ | :----- | :--- | :------------------ |
|
|
16
16
|
| 101 | 2021-01-01 10:00:00 | 1 | 1 | 2021-01-01 10:00:00 |
|
|
17
17
|
| 101 | 2021-01-01 11:00:00 | 1 | 1 | 2021-01-01 11:00:00 |
|
1
URLをリンクに
answer
CHANGED
|
@@ -39,4 +39,4 @@
|
|
|
39
39
|
, grp
|
|
40
40
|
```
|
|
41
41
|
|
|
42
|
-
http://sqlfiddle.com/#!9/2792a9/10
|
|
42
|
+
[http://sqlfiddle.com/#!9/2792a9/10](http://sqlfiddle.com/#!9/2792a9/10)
|