Subject | why the result is the number commas? |
---|---|
Author | softdestek |
Post date | 2012-06-02T17:47:06Z |
ACCOUNTS.DEBT is double
ACCOUNTS.RECEIVABLES is double
MY QUERY
SELECT
SUM(ACCOUNTS.DEBT),
SUM(ACCOUNTS.RECEIVABLES),
sum(ACCOUNTS.DEBT)-SUM(ACCOUNTS.RECEIVABLES)
FROM ACCOUNTS
WHERE ACCOUNTS.CODE='100'
1) SQL RESULT
SUM(ACCOUNTS.DEBT) 2708021,63
2) SQL RESULT
SUM(ACCOUNTS.RECEIVABLES) 2707357,52
the correct result=664,11
3)SQL RESULT
sum(ACCOUNTS.DEBT)-SUM(ACCOUNTS.RECEIVABLES) 664,109999998938
Why is this?
Why is there a difference between the two results?
ACCOUNTS.RECEIVABLES is double
MY QUERY
SELECT
SUM(ACCOUNTS.DEBT),
SUM(ACCOUNTS.RECEIVABLES),
sum(ACCOUNTS.DEBT)-SUM(ACCOUNTS.RECEIVABLES)
FROM ACCOUNTS
WHERE ACCOUNTS.CODE='100'
1) SQL RESULT
SUM(ACCOUNTS.DEBT) 2708021,63
2) SQL RESULT
SUM(ACCOUNTS.RECEIVABLES) 2707357,52
the correct result=664,11
3)SQL RESULT
sum(ACCOUNTS.DEBT)-SUM(ACCOUNTS.RECEIVABLES) 664,109999998938
Why is this?
Why is there a difference between the two results?