Sql Server Query

Mar 6 2019 12:12 PM

Hello How to create query in SQL to retrieve record like I have table by name of customer ledger It's contain columns Ledgerid, Date, Customerid, Description, DebitAmount, CreditAmount I want to sum (debit) - sum (credit) as opening_balance from the first entry date up to date 01/Mar/2019 And then Select records ,Date, Description, customer, Debit, Credit between date '' and '' Thanks