Finding a biggest number in mysql table

[saynotojava]

Let say i have five values in this structure:

Student Score

John 5

Johhy 4

Johnny 3

Jon 1

Job 2

And i want to find a value which have biggest number,in this case John.

How do i do that?

 

[cyberRobot]

Have you tried using MySQL's MAX() function?

https://dev.mysql.com/doc/refman/5.0/en/example-maximum-column.html

[ginerjm]

You do a little research on how to write sql statements.  Looking for the largest value will involve using the sql 'max' function - try looking that up and then you can write your own code.

[saynotojava]

Ok i found a proper query:

SELECT MAX(POSITION)

but it seems something is bugged here:

,when it reach number 10(i set a counter +1 on each new entry),for some reason it output number 9 as biggest number,not 10.And another thing,i have query to order by that column where i stored those numbers,but number 10 it is not last,for some reason it is sorted right after 1.

[saynotojava]

Nevermind,had to set column as INT to make it work.