Ratakan

Informations :

Query Check Account Summary Different

Query Check Account Summary Different


select sum([Debit Amount]) as 'Debit',sum([Credit Amount]) as 'Credit',sum([Debit Amount])-sum([Credit Amount]) as 'Different' from dbo.AccountSummary


Contoh :





select sum([Debit Amount]) as 'Debit',sum([Credit Amount]) as 'Credit',sum([Debit Amount])-sum([Credit Amount]) as 'Different' from dbo.AccountTransactions




No comments