Can you please help me with query

Refer this optimized query

with cte as (
      SELECT *,
      row_number() over (partition by accountno order by trandate desc) as rn
      FROM test
      )
select accountno,
       trandate,
       amount,
       paidamount,
       balance,
       coalesce(balance + (select sum(balance) from cte a where a,rn > b.rn
       and a.accountno = b.accountno ), 0) as previous_balance
from
cte b
order by b.accountno, b.trandate