Loading

sql statement question

denny simon

16y2.7kSQL

hi all

i have a question abd hope some one here give advice

I have a table table1 as below:
my question is :
how is the statement to find sum of amount for each month
//------------------------------

Amount1       Date1

1000                3/1/2010
1100              2/2/2010
1020              4/1/2010
920                12/15/2009
//----------------------------------

tq
denny

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel16y ago
Accepted answer
you can do it with following Query ..

select month(Date1),Sum(Amount) from table1 group by month(Date1);
+1