1 2 3 4 5 6 7 8 9 10 11 12
| SELECT
to_char(RUN_DATE,'dd') as "DAY",
SUM(CASE WHEN (to_char(RUN_DATE,'mm')=to_char(add_months(sysdate,-3),'mm')) THEN GEN_COUNT_CUSTOMER END) AS "GEN_COUNT_CUSTOMER_M-3",
SUM(CASE WHEN (to_char(RUN_DATE,'mm')=to_char(add_months(sysdate,-2),'mm')) THEN GEN_COUNT_CUSTOMER END) AS "GEN_COUNT_CUSTOMER_M-2",
SUM(CASE WHEN (to_char(RUN_DATE,'mm')=to_char(add_months(sysdate,-1),'mm')) THEN GEN_COUNT_CUSTOMER END) AS "GEN_COUNT_CUSTOMER_M-1",
SUM(CASE WHEN (to_char(RUN_DATE,'mm')=to_char(add_months(sysdate,0),'mm')) THEN GEN_COUNT_CUSTOMER END) AS "GEN_COUNT_CUSTOMER_M"
FROM RAS_DD_SEGMENTATION_MATRICE
WHERE SEG=:SEG
and
RUN_DATE>=add_months(sysdate,-3)
GROUP BY to_char(RUN_DATE,'dd')
ORDER BY to_char(RUN_DATE,'dd') |
Partager