from binary to decimal and displayed to only two decimal places, but
the underlying values may be !=.
-Original Message-
From: Trimurthy [mailto:trimur...@tulassi.com]
Sent: Saturday, December 29, 2012 4:26 AM
To: mysql@lists.mysql.com
Subject: Query Resulting error
hi,
i am
hi,
i am working with mysql 5.1.36 and i wrote the following query.
select total,quantity*price from sales where total != quantity*price and
salesid=122;
OUT PUT:
totalquatity*price
330.46 330.46
here quantity is 15.5 and price is 21.32
both the values and
Hi
To me it looks like quantity is being multiplied by the price and then added to
total.
Try something like this
SELECT total,(quantity*price) as QP from sales where total !=QP AND salesid=122
On 2012-12-29, at 7:25 AM, Trimurthy wrote:
hi,
i am working with mysql 5.1.36 and i