List:General Discussion« Previous MessageNext Message »
From:wang shuming Date:May 29 2006 5:13am
Subject:select sum(qty*unitpri) wrong result
View as plain text  
Hi,
  table a1

 qty int(10) , unitpri foat(10,2)
 350            19.80
   ...
350     19.80    (total 48 lines)

select sum(qty*unitpri)  from a1
332639.99  ,it should return  332640.00

mysql version 4.1.19

Best regards!

Shuming Wang

Thread
select sum(qty*unitpri) wrong resultwang shuming29 May
  • Re: select sum(qty*unitpri) wrong resultDan Nelson29 May
  • Keyword - MySQL 4.1ManojW29 May
    • Re: Keyword - MySQL 4.1Keith Roberts29 May