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