SQL-Abfrage nach Monat gruppieren

[mkinzler]

Okay bei FB < 2 ist keine Gruppierung per Alias möglich also:

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
        EXTRACT ( MONTH FROM PUB_S_D.D_DATE ), EXTRACT ( YEAR FROM PUB_S_D.D_DATE ), PUB_S_DD.BIBLE_TYPE