回答編集履歴
3
見た目
answer
CHANGED
@@ -89,11 +89,11 @@
|
|
89
89
|
|
90
90
|
| **uid** | **入場日** | **入場時間** | **入場駅** | **出場日** | **出場時間** | **出場駅** |
|
91
91
|
| ------- | ---------- | ------------ | ---------- | ---------- | ------------ | ---------- |
|
92
|
-
| A001 | 2021/09/21 | 11:28:00 | AAA | 2021/09/21 | 12:20:00 | BBB
|
92
|
+
| A001 | 2021/09/21 | 11:28:00 | AAA | 2021/09/21 | 12:20:00 | BBB |
|
93
|
-
| A001 | 2021/09/21 | 13:00:00 | BBB | 2021/09/21 | 13:30:00 | AAA
|
93
|
+
| A001 | 2021/09/21 | 13:00:00 | BBB | 2021/09/21 | 13:30:00 | AAA |
|
94
|
-
| A001 | 2021/09/22 | 23:26:00 | CCC | 2021/09/23 | 00:09:00 | DDD
|
94
|
+
| A001 | 2021/09/22 | 23:26:00 | CCC | 2021/09/23 | 00:09:00 | DDD |
|
95
|
-
| A001 | 2021/09/23 | 01:00:00 | DDD | NULL | NULL |
|
95
|
+
| A001 | 2021/09/23 | 01:00:00 | DDD | NULL | NULL | NULL |
|
96
|
-
| A002 | 2021/09/21 | 01:00:00 | AAA | 2021/09/21 | 01:30:00 | CCC
|
96
|
+
| A002 | 2021/09/21 | 01:00:00 | AAA | 2021/09/21 | 01:30:00 | CCC |
|
97
97
|
|
98
98
|
なお以下のように、window部分を共通化して記述することも可能です。
|
99
99
|
|
2
見た目
answer
CHANGED
@@ -45,15 +45,15 @@
|
|
45
45
|
|
46
46
|
| **uid** | **status** | **d** | **t** | **station** | **lead_status** | **lead_d** | **lead_t** | **lead_station** |
|
47
47
|
| ------- | ---------- | ---------- | -------- | ----------- | --------------- | ---------- | ---------- | ---------------- |
|
48
|
-
|
|
48
|
+
|A001|1|2021/09/21|11:28:00|AAA|2 |2021/09/21|12:20:00|BBB |
|
49
|
-
|
|
49
|
+
|A001|2|2021/09/21|12:20:00|BBB|1 |2021/09/21|13:00:00|BBB |
|
50
|
-
|
|
50
|
+
|A001|1|2021/09/21|13:00:00|BBB|2 |2021/09/21|13:30:00|AAA |
|
51
|
-
|
|
51
|
+
|A001|2|2021/09/21|13:30:00|AAA|1 |2021/09/22|23:26:00|CCC |
|
52
|
-
|
|
52
|
+
|A001|1|2021/09/22|23:26:00|CCC|2 |2021/09/23|00:09:00|DDD |
|
53
|
-
|
|
53
|
+
|A001|2|2021/09/23|00:09:00|DDD|1 |2021/09/23|01:00:00|DDD |
|
54
|
-
|
|
54
|
+
|A001|1|2021/09/23|01:00:00|DDD|NULL|NULL |NULL |NULL|
|
55
|
-
|
|
55
|
+
|A002|1|2021/09/21|01:00:00|AAA|2 |2021/09/21|01:30:00|CCC |
|
56
|
-
|
|
56
|
+
|A002|2|2021/09/21|01:30:00|CCC|NULL|NULL |NULL |NULL|
|
57
57
|
|
58
58
|
|
59
59
|
上記の結果から、必要な値だけを表示するようにします
|
@@ -89,11 +89,11 @@
|
|
89
89
|
|
90
90
|
| **uid** | **入場日** | **入場時間** | **入場駅** | **出場日** | **出場時間** | **出場駅** |
|
91
91
|
| ------- | ---------- | ------------ | ---------- | ---------- | ------------ | ---------- |
|
92
|
-
| A001
|
92
|
+
| A001 | 2021/09/21 | 11:28:00 | AAA | 2021/09/21 | 12:20:00 | BBB |
|
93
|
-
| A001
|
93
|
+
| A001 | 2021/09/21 | 13:00:00 | BBB | 2021/09/21 | 13:30:00 | AAA |
|
94
|
-
| A001
|
94
|
+
| A001 | 2021/09/22 | 23:26:00 | CCC | 2021/09/23 | 00:09:00 | DDD |
|
95
|
-
| A001
|
95
|
+
| A001 | 2021/09/23 | 01:00:00 | DDD | NULL | NULL | NUL |
|
96
|
-
| A002
|
96
|
+
| A002 | 2021/09/21 | 01:00:00 | AAA | 2021/09/21 | 01:30:00 | CCC |
|
97
97
|
|
98
98
|
なお以下のように、window部分を共通化して記述することも可能です。
|
99
99
|
|
1
誤植
answer
CHANGED
@@ -43,18 +43,19 @@
|
|
43
43
|
|
44
44
|
結果
|
45
45
|
|
46
|
-
| **uid** | **status** | **
|
46
|
+
| **uid** | **status** | **d** | **t** | **station** | **lead_status** | **lead_d** | **lead_t** | **lead_station** |
|
47
|
-
| ------- | ---------- | ---------- | --------
|
47
|
+
| ------- | ---------- | ---------- | -------- | ----------- | --------------- | ---------- | ---------- | ---------------- |
|
48
|
-
| A001 | 1 | 2021/09/21 | 11:28:00
|
48
|
+
| A001 | 1 | 2021/09/21 | 11:28:00 | AAA | 2 | 2021/09/21 | 12:20:00 | BBB |
|
49
|
-
| A001 | 2 | 2021/09/21 | 12:20:00
|
49
|
+
| A001 | 2 | 2021/09/21 | 12:20:00 | BBB | 1 | 2021/09/21 | 13:00:00 | BBB |
|
50
|
-
| A001 | 1 | 2021/09/21 | 13:00:00
|
50
|
+
| A001 | 1 | 2021/09/21 | 13:00:00 | BBB | 2 | 2021/09/21 | 13:30:00 | AAA |
|
51
|
-
| A001 | 2 | 2021/09/21 | 13:30:00
|
51
|
+
| A001 | 2 | 2021/09/21 | 13:30:00 | AAA | 1 | 2021/09/22 | 23:26:00 | CCC |
|
52
|
-
| A001 | 1 | 2021/09/22 | 23:26:00
|
52
|
+
| A001 | 1 | 2021/09/22 | 23:26:00 | CCC | 2 | 2021/09/23 | 00:09:00 | DDD |
|
53
|
-
| A001 | 2 | 2021/09/23 | 00:09:00
|
53
|
+
| A001 | 2 | 2021/09/23 | 00:09:00 | DDD | 1 | 2021/09/23 | 01:00:00 | DDD |
|
54
|
-
| A001 | 1 | 2021/09/23 | 01:00:00
|
54
|
+
| A001 | 1 | 2021/09/23 | 01:00:00 | DDD | « NULL » | « NULL » | « NULL » | « NULL » |
|
55
|
-
| A002 | 1 | 2021/09/21 | 01:00:00
|
55
|
+
| A002 | 1 | 2021/09/21 | 01:00:00 | AAA | 2 | 2021/09/21 | 01:30:00 | CCC |
|
56
|
-
| A002 | 2 | 2021/09/21 | 01:30:00
|
56
|
+
| A002 | 2 | 2021/09/21 | 01:30:00 | CCC | « NULL » | « NULL » | « NULL » | « NULL » |
|
57
57
|
|
58
|
+
|
58
59
|
上記の結果から、必要な値だけを表示するようにします
|
59
60
|
|
60
61
|
```sql
|