|
| SUM() problem! |
 |
Wed, 21 Nov 2007 11:04:54 +020 |
Hello,
I have problem with SUM() function in Firebird 1.5.4
Please help!
Total rows in table is 1 000 000, sumed rows is: 3934
SELECT SUM( N_ST ) FROM T_NALI WHERE C_NOMER= 'DAAD'
Result>>> 19627960,11 - that is ok
SELECT SUM( N_ST )-SUM( N_ST ) FROM T_NALI WHERE C_NOMER= 'DAAD'
Result>>> 0 - that is ok
Look this now:
SELECT SUM( N_ST )-19627960.11 FROM T_NALI WHERE C_NOMER= 'DAAD'
Result>>> 1,4901161193847 - ?????? what's happen
SELECT SUM( N_ST )-19627960.10 FROM T_NALI WHERE C_NOMER= 'DAAD'
Result>>> 0,0100000128149 - ??????
|
| Post Reply
|
| Re: SUM() problem! |
 |
Wed, 21 Nov 2007 11:56:38 +010 |
> I have problem with SUM() function in Firebird 1.5.4
Why are you asking that question here? This is an InterBase
newsgroup.
Firebird has it's own support lists - check the Firebird website.
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
|
| Post Reply
|
| Re: SUM() problem! |
 |
Wed, 21 Nov 2007 12:22:06 +020 |
Thanks
I slove the problem, it is in EMS Manager float format!
|
| Post Reply
|
|
|
|
|
|
|
|
|
|