-
Group by date with a SUM - Can't think!!
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|