回答編集履歴
3
編集
test
CHANGED
@@ -1,4 +1,4 @@
|
|
1
|
-
上の方を
|
1
|
+
上の方のを参考に書かせていただきました。
|
2
2
|
|
3
3
|
```sql
|
4
4
|
|
2
timestamp対応
test
CHANGED
@@ -6,9 +6,9 @@
|
|
6
6
|
|
7
7
|
from log
|
8
8
|
|
9
|
-
where import_date >= '2016-08-01'
|
9
|
+
where import_date::date >= '2016-08-01'
|
10
10
|
|
11
|
-
AND import_date <= '2016-08-04'
|
11
|
+
AND import_date::date <= '2016-08-04'
|
12
12
|
|
13
13
|
AND status = 'NG'
|
14
14
|
|
1
変更
test
CHANGED
@@ -12,6 +12,6 @@
|
|
12
12
|
|
13
13
|
AND status = 'NG'
|
14
14
|
|
15
|
-
group by 1
|
15
|
+
group by 1 order by 1
|
16
16
|
|
17
17
|
```
|