| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Trimurthy | Date: | December 29 2012 12:25pm |
| Subject: | Query Resulting error | ||
| View as plain text | |||
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:
total quatity*price
330.46 330.46
here quantity is 15.5 and price is 21.32
both the values and data types are double(total,quantity and price). can
anyone tell me why this is happening.
Normal 0 false false false EN-US
X-NONE AR-SA
Thanks & Kind Regards,
TRIMURTHY
| Thread | ||
|---|---|---|
| • Query Resulting error | Trimurthy | 29 Dec |
| • Re: Query Resulting error | Mike O'Krongli | 29 Dec |
| • RE: Query Resulting error | Rick James | 7 Jan 2013 |
