1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Getting previous balance before transaction date in oracle

Discussion in 'SQL PL/SQL' started by badanikareem, Aug 17, 2017.

  1. badanikareem

    badanikareem Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    yemen
    Hi Guys,
    I want to make a query to get the transaction and current balance between two days and at the same time to get previous balance before the date in the WHERE condition so I make the following query. Can Anyone help me to do that. I have attached the script of the table and queries that didn't work. If anyone interested, please follow the points in the attachment (01_Notes.txt).

    Thanks in advance
     

    Attached Files: