erted 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:
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 wro
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
