teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

4

修正

2017/05/30 07:25

投稿

SVC34
SVC34

スコア1149

answer CHANGED
@@ -3,7 +3,7 @@
3
3
  ```sql
4
4
  SELECT
5
5
  t.sabun
6
- ,t.count(*)
6
+ ,count(*)
7
7
  FROM
8
8
  (
9
9
  SELECT

3

修正

2017/05/30 07:25

投稿

SVC34
SVC34

スコア1149

answer CHANGED
@@ -20,6 +20,6 @@
20
20
  AND t_r.id = t_s.id
21
21
  AND t_r.name = t_s.name
22
22
  ) AS t
23
- GROUP BY sabun
23
+ GROUP BY t.sabun
24
- ORDER BY sabun
24
+ ORDER BY t.sabun
25
25
  ```

2

修正

2017/05/30 07:25

投稿

SVC34
SVC34

スコア1149

answer CHANGED
@@ -2,8 +2,8 @@
2
2
 
3
3
  ```sql
4
4
  SELECT
5
- sabun
5
+ t.sabun
6
- ,count(*)
6
+ ,t.count(*)
7
7
  FROM
8
8
  (
9
9
  SELECT
@@ -19,6 +19,7 @@
19
19
  AND t_s.joukyou = 'soushin'
20
20
  AND t_r.id = t_s.id
21
21
  AND t_r.name = t_s.name
22
- )
22
+ ) AS t
23
23
  GROUP BY sabun
24
+ ORDER BY sabun
24
25
  ```

1

追記

2017/05/30 07:20

投稿

SVC34
SVC34

スコア1149

answer CHANGED
@@ -1,17 +1,24 @@
1
- 自己結合でIDとNAMEが同じ受信レコードと送信レコードを結合してください。
1
+ 自己結合でIDとNAMEが同じ受信レコードと送信レコードを結合し、その結果をGROUP BYしてください。
2
2
 
3
3
  ```sql
4
4
  SELECT
5
- t_r.id
5
+ sabun
6
- ,t_r.name
6
+ ,count(*)
7
- ,t_r.jikan AS jushin_jikan
8
- ,t_s.jikan AS soushin_jikan
9
- ,DATEDIFF(millisecond, t_r.jikan, t_r.jikan) AS sabun
10
7
  FROM
8
+ (
9
+ SELECT
10
+ t_r.id
11
+ ,t_r.name
12
+ ,t_r.jikan AS jushin_jikan
13
+ ,t_s.jikan AS soushin_jikan
14
+ ,DATEDIFF(millisecond, t_r.jikan, t_r.jikan) AS sabun
15
+ FROM
11
- tablename AS t_r
16
+ tablename AS t_s
12
- INNER JOIN tablename AS t_s
17
+ INNER JOIN tablename AS t_r
13
- ON t_r.joukyou = 'jushin'
18
+ ON t_r.joukyou = 'jushin'
14
- AND t_s.joukyou = 'soushin'
19
+ AND t_s.joukyou = 'soushin'
15
- AND t_r.id = t_s.id
20
+ AND t_r.id = t_s.id
16
- AND t_r.name = t_s.name
21
+ AND t_r.name = t_s.name
22
+ )
23
+ GROUP BY sabun
17
24
  ```