回答編集履歴
1
追記
answer
CHANGED
|
@@ -36,4 +36,17 @@
|
|
|
36
36
|
AND _index is NOT NULL
|
|
37
37
|
) zdp
|
|
38
38
|
GROUP BY A._id
|
|
39
|
+
```
|
|
40
|
+
日付毎に出力したいという事なら、そもそもgroup byの指定が正しくありません。
|
|
41
|
+
```SQL
|
|
42
|
+
SELECT dt , count(*) as cnt
|
|
43
|
+
FROM A.Atable
|
|
44
|
+
WHERE corpid = 1
|
|
45
|
+
AND (
|
|
46
|
+
(dt >= 20201224 AND dt <= 20201224)
|
|
47
|
+
OR (dt >= 20201225 AND dt <= 20201225)
|
|
48
|
+
)
|
|
49
|
+
AND "$word" LIKE '%id.%'
|
|
50
|
+
AND _index is NOT NULL
|
|
51
|
+
GROUP BY dt
|
|
39
52
|
```
|