Hi,

Hopefully, someone will have a quick and easy answer for me...

I have a (theoretical) table with 2 columns, POSTING_DATE and AMOUNT

POSTING_DATE can be any day of the year.

I need to output something that looks like this.....

Month Amount Sum

Jan-04 123,456 (whatever the sum is)
Feb-04 345,678
Mar-04
...
...
Dec-04 999,999


I'm looking at 'Select posting_date,sum(amount)
from table
group by posting_date;


But I'm having trouble grouping into months, and struggling with the date mask.

Please help, can't think today. Thanks.