SELECT MAX(scorevalue) FROM score
Will display the maximum value of your scorevalue column.
Sincerely,
Craig Vincent
--
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
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 *
select max(scorevalue) from score;
- Original Message -
From: Jacky [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 2001. május 21. 22:38
Subject: [PHP] select the max value
Hi all
Is this the corerct way of selecting the max value in a table?
select * from score where MAX(scorevalue)
3 matches
Mail list logo