Ending balance and begining balance

• anbu

  SSC-Addicted

  Points: 407

  More actions

  June 9, 2003 at 11:39 pm

  #105761

  I have a situation like this. Daily income, daily outcome are the measures. The ending balance=begining balance+total income-total outcome. For the first day, begining balance is zero but there should be ending balace and from next day onwards the previous day ending balance is today's begining balance. Do anyone have any idea how to solve this issue? Please reply to me ASAP. It is very very urgent.

  Thanks in advance,

  Anbu

• June 12, 2003 at 8:00 am

  This was removed by the editor as SPAM

• NPeeters

  SSChampion

  Points: 12536

  More actions

  June 12, 2003 at 9:33 am

  #461073

  You can use the following query.

  
  
  SELECT t1.bal_date,
  
       (SELECT sum(income - outcome)
  
        FROM your_table t2
  
        WHERE t2.bal_date <= t1.bal_date)
  
  FROM your_table t1