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.