List:General Discussion« Previous MessageNext Message »
From:Richard Reina Date:January 21 2001 6:48pm
Subject:SELECT FROM TABLE WHERE ?
View as plain text  
I've tried the manual (and the Oreily MySQL book) and played around with
MAX() and GREATEST() but could not figure it out.


|ID	|NAME		|RATING	|
|213	|McCallen 12	|   9	|
|214	|Glenmorangie   |   8	|
|225	|Glenlevit	|   7	|

How do I select the one with highest rating without knowing what the
highest rating is.

SELECT ID, NAME, RATING 
FROM SINGLEMALTS
WHERE RATING ????
Thread
SELECT FROM TABLE WHERE ?Richard Reina22 Jan
  • RE: SELECT FROM TABLE WHERE ?Cal Evans23 Jan
  • Re: SELECT FROM TABLE WHERE ?Web master23 Jan
  • Re: SELECT FROM TABLE WHERE ?Harald Fuchs23 Jan
  • Re: SELECT FROM TABLE WHERE ?Angela25 Jan