Select Highest Value

[andz]

I have stumbled on a problem with regards to selecting the highest value from a table.

 

I have this data on my table::

 

price

1,000,000.00

3,000,000.00

500.00

23.00

5,234,234.53

 

I used SELECT * FROM `table_name` ORDER BY `price` DESC;

 

but instead of returning the highest value, that's not what happened.

 

price field is varchar(20)

 

any possible query codes would be accepted.

 

thank you.

[corbin]

First off, use MAX if you want the 1 highest value.

 

Second, numerical comparisons and string fields do not go well.

 

 

Use float, or better yet, decimal for the field.

 

Example:

 

 

SELECT MAX(price) FROM table_name;

[borabora12]

instead of making the field named price varchar(20) you should make it decimal(18,2) in that case it will work using the DESC function.

 

in decimal(18,2) the 2 represents how many spaces from the right the decimal will be placed from. And 18 represents how many digits come left of the decimal point. hope this helps.