sql如下:
SELECT
A .xx,
b.综合
FROM
(SELECT DISTINCT
TO_CHAR (
TO_DATE (
'2019/01',
'yyyy/mm'
) + (LEVEL - 1),
'yyyymm'
) AS xx
FROM
dual CONNECT BY TRUNC (
TO_DATE (
'2019/01',
'yyyy/mm'
)
) + LEVEL - 1 <= TRUNC (
TO_DATE (
'2019/12',
'yyyy/mm'
)
)
) A
LEFT JOIN (
SELECT
TO_CHAR (TRUNC(T .TODATE), 'yyyymm') x,
SUM (T .OTATAMT + T .INTAMT) 综合
FROM
VLOAAPLPLNM T
GROUP BY
TO_CHAR (TRUNC(T .TODATE), 'yyyymm')
) b ON A .xx = b.x
ORDER BY
A .xx
效果预览: