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
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