denny simon

denny simon

  • NA
  • 57
  • 0

sql statement question

Mar 12 2010 7:44 PM
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



Answers (1)