计算每个月的累计薪资是多少？一月份赚了3000，二月份赚了6000，想二月份变成9000，每一次都是累加的

id     name   month    salary
e001  manish   1   		10000
e001  manish   2   		20000
e001  manish   3   		30000
e002  rohit    1   		30000

输出应该如下所示

id    name    month    salary     cumsalary
e001  manish   1	   10000		  10000
e001  manish   2	   20000		  30000
e001  manish   3	   30000		  60000
e002  rohit    1	   30000       	  30000

sql:

select t1.* ,
sum(salary) over (partition by id order by id) cumsalary
from table t1