回答編集履歴

1

補完

2015/02/19 00:13

投稿

jcs502ulf
jcs502ulf

スコア307

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
+ ```