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
LVL 16
hankknightAsked:
Who is Participating?
 
SharathConnect With a Mentor Data EngineerCommented:
Do you want to round to 5 digits?
see this. http://sqlfiddle.com/#!2/d93a2/10
0
 
SharathData EngineerCommented:
I didn't get the question. What is the expected value?
0
 
hankknightAuthor Commented:
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
0
All Courses

From novice to tech pro — start learning today.