teratail
回答率
85.47%
質問するログイン新規登録
トップに関する質問SQLで抽出が上手くいきません。

編集履歴

質問編集履歴

2

指定が誤っていたため

2018/02/16 03:02

投稿

testuser3
testuser3

スコア12

test CHANGED
File without changes
test CHANGED
@@ -54,70 +54,6 @@
54
54
 
55
55
  ### 試したこと
56
56
 
57
- 副問い合わせで取得したデータ
58
-
59
- "2017-08-25 21:08:23.781212"
60
-
61
- "2017-08-31 11:53:57.611001"
62
-
63
- "2017-09-03 21:01:44.150238"
64
-
65
- "2017-09-03 21:25:13.851899"
66
-
67
- "2017-09-04 11:49:11.308398"
68
-
69
- "2017-09-07 19:46:39.479238"
70
-
71
- "2017-09-07 20:10:00.579781"
72
-
73
- "2017-09-13 18:20:28.563506"
74
-
75
- "2017-09-14 13:41:09.415794"
76
-
77
- "2017-11-05 08:05:08.879644"
78
-
79
- "2017-11-13 05:41:42.003599"
80
-
81
- "2017-11-21 13:10:32.979089"
82
-
83
- "2017-12-07 14:17:38.084846"
84
-
85
- "2017-09-02 06:01:50.581042"
86
-
87
- "2017-12-26 14:10:49.506682"
88
-
89
- "2018-01-16 11:31:55.732312"
90
-
91
- "2018-02-07 11:54:35.649705"
92
-
93
- "2018-02-08 16:32:19.541341"
94
-
95
- "2017-09-02 15:22:54.113373"
96
-
97
- "2017-09-12 18:41:25.905621"
98
-
99
- "2017-10-05 16:43:23.381248"
100
-
101
- "2017-10-21 17:17:11.256554"
102
-
103
- "2017-11-06 10:17:12.597965"
104
-
105
- "2017-11-12 14:40:48.633782"
106
-
107
- "2017-12-07 11:57:47.662806"
108
-
109
- "2017-12-14 17:50:45.668955"
110
-
111
- "2017-09-13 18:23:57.784051"
112
-
113
- "2017-09-02 21:06:16.253162"
114
-
115
-
116
-
117
-
118
-
119
-
120
-
121
57
 
122
58
 
123
59
  ### 補足情報（FW/ツールのバージョンなど）

1

副問い合わせのデータについて

2018/02/16 03:02

投稿

testuser3
testuser3

スコア12

test CHANGED
File without changes
test CHANGED
@@ -54,9 +54,69 @@
54
54
 
55
55
  ### 試したこと
56
56
 
57
+ 副問い合わせで取得したデータ
58
+
59
+ "2017-08-25 21:08:23.781212"
60
+
61
+ "2017-08-31 11:53:57.611001"
62
+
63
+ "2017-09-03 21:01:44.150238"
64
+
65
+ "2017-09-03 21:25:13.851899"
66
+
67
+ "2017-09-04 11:49:11.308398"
68
+
69
+ "2017-09-07 19:46:39.479238"
70
+
71
+ "2017-09-07 20:10:00.579781"
72
+
73
+ "2017-09-13 18:20:28.563506"
74
+
75
+ "2017-09-14 13:41:09.415794"
76
+
77
+ "2017-11-05 08:05:08.879644"
78
+
79
+ "2017-11-13 05:41:42.003599"
80
+
81
+ "2017-11-21 13:10:32.979089"
82
+
83
+ "2017-12-07 14:17:38.084846"
84
+
85
+ "2017-09-02 06:01:50.581042"
86
+
87
+ "2017-12-26 14:10:49.506682"
88
+
89
+ "2018-01-16 11:31:55.732312"
90
+
91
+ "2018-02-07 11:54:35.649705"
92
+
93
+ "2018-02-08 16:32:19.541341"
94
+
95
+ "2017-09-02 15:22:54.113373"
96
+
97
+ "2017-09-12 18:41:25.905621"
98
+
99
+ "2017-10-05 16:43:23.381248"
100
+
101
+ "2017-10-21 17:17:11.256554"
102
+
103
+ "2017-11-06 10:17:12.597965"
104
+
105
+ "2017-11-12 14:40:48.633782"
106
+
107
+ "2017-12-07 11:57:47.662806"
108
+
109
+ "2017-12-14 17:50:45.668955"
110
+
111
+ "2017-09-13 18:23:57.784051"
112
+
113
+ "2017-09-02 21:06:16.253162"
57
114
 
58
115
 
59
- ここに問題に対して試したことを記載してください。
116
+
117
+
118
+
119
+
60
120
 
61
121
 
62
122