回答編集履歴
1
補完
test
CHANGED
@@ -5,3 +5,21 @@
|
|
5
5
|
extract(month from day_table.day) = extract(month from sysdate)
|
6
6
|
|
7
7
|
```
|
8
|
+
|
9
|
+
|
10
|
+
|
11
|
+
具体的には、元のSQLに条件を加えます。
|
12
|
+
|
13
|
+
```lang-SQL
|
14
|
+
|
15
|
+
select company,day,
|
16
|
+
|
17
|
+
trunc(months_between(sysdate,day)/12+0.999)
|
18
|
+
|
19
|
+
from company_table,day_table
|
20
|
+
|
21
|
+
where company_table.code=day_table.code
|
22
|
+
|
23
|
+
and extract(month from day_table.day) = extract(month from sysdate)
|
24
|
+
|
25
|
+
```
|