how to sum previous row to next row in different column?

Anand SA

any idea guys how to sum previous row to next row in different column?...i'm using mysql 5.6... or is there a way using datagridview?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Joshi4y ago

Hello Anand,

You can try the below query to get the expected result.

SELECT 
    s.Id,s.trx_amtdue, s.trx_amt,
    SUM(s.trx_overdue + s.trx_amtdue) OVER (ORDER BY s.Id
                                  ROWS BETWEEN UNBOUNDED PRECEDING
                                           AND CURRENT ROW)
        AS trx_overdue
FROM
    tblTransaction AS s
ORDER BY
    Id;

Rajanikant Hawaldar4y ago
can you test it?
```
decimal pre_overd=0.0m;
decimal amtd=0.0m;
for (int i=1;i
```