Link to home
Create AccountLog in
Avatar of hankknight
hankknightFlag for Canada

asked on

MySQL: MIN() and MAX() and MAX()-MIN() Inacurate

In this example, I want to get the minimum and maximum values of a matching column, as well as the difference between them.

However the results do not match the values in the database.

http://sqlfiddle.com/#!2/d93a2/3
Avatar of Sharath S
Sharath S
Flag of United States of America image

I didn't get the question. What is the expected value?
Avatar of hankknight

ASKER

The value of:
BIDMIN_SHOULD_BE_0_94693
Should be:
0.94693

The value of:
BIDMAX_SHOULD_BE_0_94793
Should be:
0.94793

The value of:
BID_RANGE_SHOULD_BE_0_001
0.001

http://sqlfiddle.com/#!2/d93a2/3
ASKER CERTIFIED SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account