回答編集履歴
2
目視でぬけてるのがきづいた・・・
answer
CHANGED
|
@@ -14,6 +14,7 @@
|
|
|
14
14
|
FROM
|
|
15
15
|
wp.wp_slim_stats
|
|
16
16
|
)
|
|
17
|
+
GROUP BY CDT
|
|
17
18
|
ORDER BY CDT
|
|
18
19
|
```
|
|
19
20
|
|
1
カラムのかぶりをなくす
answer
CHANGED
|
@@ -6,15 +6,15 @@
|
|
|
6
6
|
|
|
7
7
|
```
|
|
8
8
|
SELECT
|
|
9
|
-
|
|
9
|
+
CDT,
|
|
10
|
-
COUNT(
|
|
10
|
+
COUNT(CDT) AS PV
|
|
11
11
|
FROM (
|
|
12
12
|
SELECT
|
|
13
|
-
DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') as
|
|
13
|
+
DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') as CDT
|
|
14
14
|
FROM
|
|
15
15
|
wp.wp_slim_stats
|
|
16
16
|
)
|
|
17
|
-
ORDER BY
|
|
17
|
+
ORDER BY CDT
|
|
18
18
|
```
|
|
19
19
|
|
|
20
20
|
# ケース２
|
|
@@ -23,11 +23,11 @@
|
|
|
23
23
|
|
|
24
24
|
```
|
|
25
25
|
SELECT
|
|
26
|
-
DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') as
|
|
26
|
+
DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') as CDT,
|
|
27
27
|
COUNT(id) AS PV
|
|
28
28
|
FROM
|
|
29
29
|
wp.wp_slim_stats
|
|
30
|
-
GROUP BY DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') //
|
|
30
|
+
GROUP BY DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') // CDT できたかもしれんが...
|
|
31
|
-
ORDER BY DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') //
|
|
31
|
+
ORDER BY DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') // CDT できたかもしれんが...
|
|
32
32
|
|
|
33
33
|
```
|