Wrong Answer MySQL SUM

Asked by At

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

0 Answers