MYSQL how to query out current balance as previous balance

Question

I need to make a query with the expected result as below. Consider the prev. Balance is auto-calculated field. And i want to populate with MYSQL query by taking the Balance (from previous row) see picture. How to query out using mysql? The date can be any date not sequential and that below is just an illustration.

Note that the previous balance is just a sequence of the old balance. Meaning that the first previous balance always null or zero and the balance get its amount from added amount. From the first balance the second record start to have its previous balance and it goes on and on

Answer 1

you can use row_number() to be used for left join your previous balance.

select t1.*, t2.PrevBalance from
    (select Date, PrevBalance, AddedAmount,
        row_number() over (order by Date asc) as rn 
    from tableA) t1    
left join 
    (select Date, PrevBalance, AddedAmount,
        row_number() over (order by Date asc) as rn 
    from tableA) t2 on t2.rn + 1 = t1.rn