MySQL (get max number)

[anneveld]

Hi all,

I'm trying to get a max number of a row like 45 in this row.



+-----------+
| number
+-----------+
| 4
| 45
| 3
| 1
+-----------+



and i don't know how i set my query

could you please help me ?

Tanks

[AdamGundry]

I think you want a query like this:
SELECT MAX(number) AS number FROM table

See http://www.mysql.com/doc/en/example-Maximum-column.html

Adam

[anneveld]

Adam thank you just what i need.

:)