Re: [PHP] select the max value

2001-05-21 Thread Gyozo Papp 

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)"
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]

Re: [PHP] select the max value

2001-05-21 Thread Tom Rogers 

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]

RE: [PHP] select the max value

2001-05-21 Thread Craig Vincent 

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 administrators, e-mail: [EMAIL PROTECTED]