SQL-Abfrage nach Monat gruppieren

[mkinzler]

SQL-Code:

SELECT EXTRACT ( MONTH FROM PUB_S_D.D_DATE ) S_MONTH,
       EXTRACT ( YEAR FROM PUB_S_D.D_DATE ) S_YEAR,
       PUB_S_DD.BIBLE_TYPE,
       SUM (PUB_S_DD.AMOUNT) AS TOT_AMOUNT
FROM 
       PUB_S_D
           INNER JOIN PUB_S_DD ON (PUB_S_D.ID = PUB_S_DD.ID_D)
GROUP BY 
        S_MONTH, S_YEAR, PUB_S_DD.BIBLE_TYPE