MySQL Forums
Forum List  »  Newbie

ordering by float values
Posted by: D MA
Date: September 03, 2004 05:53AM

Hi,

Ive got an SELECT statement and want to order it by a field which is a float. This produces some strange results ie:

2.05
2.3
2.4
2

Was just wondering why this is happening and is there a way round it.

First time using floats btw

TIA,
Doug

Options: ReplyQuote


Subject
Written By
Posted
ordering by float values
September 03, 2004 05:53AM
September 03, 2004 12:12PM
September 04, 2004 03:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.