Hi
try:
select * from score order by scorevalue DESC LIMIT 1
or if your db supports sub selects:
select * from score where scorevalue=(select MAX(scorevalue) from score)
Tom
At 03:38 PM 21/05/01 -0500, Jacky wrote:
>Hi all
>Is this the corerct way of selecting the max value in a table?
>"select * from score where MAX(scorevalue)"
>cheers
>Jack
>[EMAIL PROTECTED]
>"There is nothing more rewarding than reaching the goal you set for yourself"
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
