I have a Table TransactionID
Credit
Dated
AccName
. I want Get Sum Value in Credit
Column. this Some Value Working good in localhost. but online server Wrong Sum value return.
tbtransaction
TransactionID AccName Credit Dated
-----------------------------------------------------------
1 CASH ACCOUNT 8,850,890 2019-03-31
2 CASH ACCOUNT 119,870 2019-03-31
3 CASH ACCOUNT 4,400 2019-03-31
4 CASH ACCOUNT 2,090 2019-03-31
5 CASH ACCOUNT 700 2019-03-31
6 CASH ACCOUNT 600 2019-03-31
7 CASH ACCOUNT 300 2019-03-31
my query
SELECT SUM(Credit) as debitbalance FROM tbtransaction WHERE AccName='CASH ACCOUNT'
and Dated BETWEEN '2019-03-31' AND '2019-03-31'ORDER BY TransactionID ASC
sum value 8978850
its correct value getting on locallhost
but online server getting 8978852
What is Wrong with my Code