[V4WS 1.11] Re: Retrieving field values of record found with MAX

[Steven Ronald]

If I have a table x:

foo    bar   hooh
0.3    3       45
0.2    4       87
0.6    3       23
0.5    6       33

is it possible to use a single SQL statement to find
the value of hooh for the record with the maximum
value of foo (ie hooh=23)?

SELECT  MAX(foo),hooh FROM x GROUP BY hooh

does not work - it returns all 4 records.

Best Regards,
Steven



Send instant messages to your online friends http://au.messenger.yahoo.com