The original table

After the query table

Requirement is by each month accumulative total value, seek out the monthly value of each month
Please bosses

CodePudding user response:

Select a1. *, decode (M, 1, nim_total nim_total - (select nim_total from the original table a2 where a1. Y=a2. Y. and a2, M=a1. M - 1)) t the from the original table a1