回答編集履歴
1
修正
answer
CHANGED
|
@@ -2,7 +2,7 @@
|
|
|
2
2
|
|
|
3
3
|
```sql
|
|
4
4
|
SELECT
|
|
5
|
-
DATE_FORMAT(A.`date`, '%Y-%m-%d %H:%
|
|
5
|
+
DATE_FORMAT(A.`date`, '%Y-%m-%d %H:%i') AS `dt`
|
|
6
6
|
, SUBSTRING_INDEX( GROUP_CONCAT(CAST(`value` AS CHAR) ORDER BY `date`), ',', 1 ) AS `first`
|
|
7
7
|
, SUBSTRING_INDEX( GROUP_CONCAT(CAST(`value` AS CHAR) ORDER BY `date` DESC), ',', 1 ) AS `last`
|
|
8
8
|
, min(A.`VALUE`) AS `min`
|
|
@@ -10,5 +10,5 @@
|
|
|
10
10
|
FROM
|
|
11
11
|
`sample` A
|
|
12
12
|
GROUP BY
|
|
13
|
-
DATE_FORMAT(A.`DATE`, '%Y-%m-%d %H:%
|
|
13
|
+
DATE_FORMAT(A.`DATE`, '%Y-%m-%d %H:%i')
|
|
14
14
|
```
|