denny simon

denny simon

  • NA
  • 57
  • 0

to sum value in a table

Mar 1 2010 12:02 AM
hello all

i have table1 with 2 columns
column1 for datetime
column2 for integer value

Date                          value
2/2/2010                    100
2/4/2010                    200

3/5/2010                     90
3/6/2010                     110

how is the statement to sum the value in pebruary,in march etc.

tq
denny

Answers (2)