質問編集履歴
4
誤字修正しました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -52,11 +52,11 @@
|
|
52
52
|
|
53
53
|
AND CA.CHIRASHI_KANRI_NO= AND CB.CHIRASHI_KANRI_NO
|
54
54
|
|
55
|
-
GROUP BY TO_CHAR(CA.524T_JISSI_YMD,'YYYYMM'),CA.524T_JYU_SYAIN_CD)
|
55
|
+
GROUP BY TO_CHAR(CA.524T_JISSI_YMD,'YYYYMM'),CA.524T_JYU_SYAIN_CD) C
|
56
56
|
|
57
57
|
WHERE TO_CHAR(A.522T_JISSI_YMD,'YYYYMM') = TO_CHAR(C.JISSI_YMD(+),'YYYYMM')
|
58
58
|
|
59
|
-
AND A.522T_JYU_SYAIN_CD = C.JYU_SYAIN_CD(+))
|
59
|
+
AND A.522T_JYU_SYAIN_CD = C.JYU_SYAIN_CD(+))
|
60
60
|
|
61
61
|
FROM RDL522T_JYU_SYAIN_NIPPO A
|
62
62
|
|
3
誤字修正、インデントつけました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -52,7 +52,7 @@
|
|
52
52
|
|
53
53
|
AND CA.CHIRASHI_KANRI_NO= AND CB.CHIRASHI_KANRI_NO
|
54
54
|
|
55
|
-
GROUP BY TO_CHAR(CA.524T_JISSI_D
|
55
|
+
GROUP BY TO_CHAR(CA.524T_JISSI_YMD,'YYYYMM'),CA.524T_JYU_SYAIN_CD)
|
56
56
|
|
57
57
|
WHERE TO_CHAR(A.522T_JISSI_YMD,'YYYYMM') = TO_CHAR(C.JISSI_YMD(+),'YYYYMM')
|
58
58
|
|
2
kkk
test
CHANGED
File without changes
|
test
CHANGED
@@ -21,6 +21,8 @@
|
|
21
21
|
|
22
22
|
|
23
23
|
###該当のソースコード
|
24
|
+
|
25
|
+
```lang-sql
|
24
26
|
|
25
27
|
SELECT TO_CHAR(A.RDL522T_JISSI_YMD,'YYYYMM') AS TAISYO_YM
|
26
28
|
|
@@ -66,7 +68,9 @@
|
|
66
68
|
|
67
69
|
AND A.522T_JYU_SYAIN_CD = B.014P_JYUIN_SYA_CD
|
68
70
|
|
69
|
-
GROUP BY TO_CHAR(A.522T_JISSI_D
|
71
|
+
GROUP BY TO_CHAR(A.522T_JISSI_YMD,'YYYYMM'),A.RDL522T_JYU_SYA_CD,A.522T_JYU_SYAIN_CD,B.RDL014P_JYU_JIGYOSYO_CD,B.RDL014P_JYU_NM
|
72
|
+
|
73
|
+
```
|
70
74
|
|
71
75
|
|
72
76
|
|
1
GROUP BY BY になってました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -50,7 +50,7 @@
|
|
50
50
|
|
51
51
|
AND CA.CHIRASHI_KANRI_NO= AND CB.CHIRASHI_KANRI_NO
|
52
52
|
|
53
|
-
GROUP BY
|
53
|
+
GROUP BY TO_CHAR(CA.524T_JISSI_DATE,'YYYYMM'),CA.524T_JYU_SYAIN_CD)
|
54
54
|
|
55
55
|
WHERE TO_CHAR(A.522T_JISSI_YMD,'YYYYMM') = TO_CHAR(C.JISSI_YMD(+),'YYYYMM')
|
56
56
|
|