[Resolved] query problem

[k994519]

Hi guys,

Can some one please help me with this query

I need to print out the highest value in the field student_id from table

how do i do this

thanks for ur help

[sidney]

SELECT student_id FROM table ORDER BY student_id DESC LIMIT 1

should give you the row with the highest student_id
or else you could try search mysql manuel max()

[k994519]

thanks sidney