SELECT
TO_CHAR( CREATE_TIME, ‘YYYY-MM’ ) AS cct,
SYSTEM_NAME ,
MONTHLY_CLICKS AS “monthlyClicks”
FROM
DIM_SYSTEM
WHERE
add_months( SYSDATE,- 12 ) <= CREATE_TIME
GROUP BY
TO_CHAR( CREATE_TIME, ‘YYYY-MM’ ),
SYSTEM_NAME,
MONTHLY_CLICKS
ORDER BY
TO_CHAR( CREATE_TIME, ‘YYYY-MM’ )
字段拼接
SELECT
TO_CHAR( CREATE_TIME, ‘YYYY-MM’ ) ,
listagg(SYSTEM_NAME,‘,’) AS systemName,
listagg(MONTHLY_CLICKS,‘,’) AS monthlyClicks
FROM
DIM_SYSTEM
WHERE
add_months( SYSDATE,- 12 ) <= CREATE_TIME
GROUP BY
TO_CHAR( CREATE_TIME, ‘YYYY-MM’ )
ORDER BY
TO_CHAR( CREATE_TIME, ‘YYYY-MM’ )