?

Search Help Board

PHP FAQ
PHP Articles
PHP Help
Bulletin Board
PHP Manual (NEW!)
First Time PHP'ers
Help with programming
Sql assignment help
PHP Homework Help


C# Help

?
New Topic??|??Go to Top??|??Go to Topic??|??Threaded View??|??Search?
?Newer Topic??|??Older Topic
?Query question
Author:??(---.58.153.10.Dial1.Portland1.Level3.net)
Date:???07-12-03 01:30

I have a query that selects the maximum value in a column:

"select max(columnname) from table where . . . ."

This returns the value in that field. How can I query the database to return all the info in a row with the maximum value in a particular column? I'm sure this is pretty simple, but my eyes are starting to bug out of my head, and I remain a lowly newbie.
Thanks

Reply To This Message
?Re: Query question
Author:??(---.cpe.net.cable.roger)
Date:???07-12-03 07:15

what is the db...some don't certain ways of doing things (like subselects)?

Reply To This Message
?Re: Query question
Author:??(---.75.227.175.Dial1.Seattle.Level3.net)
Date:???07-12-03 08:50

It's a mysql database.

Reply To This Message
?Re: Query question
Author:??(---.cpe.net.cable.roger)
Date:???07-12-03 11:33

select * from table
order by columnname
limit 1

since mysql does not support subselect which would be the easiest way...the above should do what you want...the limit clause keeps the result set to one row

hth

Reply To This Message
?Re: Query question
Author:??(---.cpe.net.cable.roger)
Date:???07-13-03 17:43

sorry that sshould be

select * from table
order by columnname desc //keyword to oder from high to low
limit 1

Reply To This Message
Go to Top??|??Go to Topic??|??Threaded View??|??Search?
??|??
New Topic
?Reply To This Message
?Your Name:
?Your Email:
?Subject:
Email replies to this thread, to the address above.
??

Provided By
Phorum