MySQL Lists: mysql: select sum(qty*unitpri) wrong result

List:	General Discussion	« Previous Message Next 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(qtyunitpri) wrong result**	wang shuming	29 May
• Re: select sum(qty*unitpri) wrong result	Dan Nelson	29 May
• Keyword - MySQL 4.1	ManojW	29 May
• Re: Keyword - MySQL 4.1	Keith Roberts	29 May