select the max value
| From: | Jacky | Date: | Mon, 21 May 2001 20:38:02 +0000 |
| Subject: | select the max value | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-53680@lists.php.net to get a copy of this message | ||
Hi all
Is this the corerct way of selecting the max value in a table?
"select * from score where MAX(scorevalue)"
cheers
Jack
jacky@activelifestyle.com
"There is nothing more rewarding than reaching the goal you set for yourself"