Cumulative sum in a Select Statement

How can I do a cumulative sum for a given numeric column using the SELECT statement. For instance,

values CumulativeSum

  1	     1	
  2	     3
  3          6
  4         10

Any idea ?

Thanks.

Bernard.
bbcc_at_istar.ca Received on Wed Mar 19 1997 - 00:00:00 CST